home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
table_compression

keyboard_arrow_leftGo to View Parameter List

Usage

view: my_view {
  derived_table: {
    table_compression: GZIP
    …
  }
}

Hierarchy

table_compression

Default Value

GZIP

Accepts

GZIP or SNAPPY

Special Rules

table_compression is supported only on specific dialects

Definition

The table_compression parameter specifies the compression that a persistent derived table (PDT) will have in an Athena database, either GZIP or SNAPPY.

See the Amazon Athena documentation for details.

See the Dialect Support for table_compression section below for the list of dialects that support table_compression.

The table_compression parameter works only with tables that are persistent, such as PDTs and aggregate tables. table_compression is not supported for derived tables without a persistence strategy.

Examples

Create a customer_order_facts PDT on an Amazon Athena database with SNAPPY compression:

view: customer_order_facts { derived_table: { explore_source: order { column: customer_id { field: order.customer_id } column: date { field: order.order_time } column: city { field: users.city } column: age_tier { field: users.age_tier } derived_column: num_orders { sql: COUNT(order.customer_id) ;; } } table_format: ORC table_compression: SNAPPY datagroup_trigger: daily_datagroup } }

Dialect support for table_compression

The ability to use table_compression depends on the database dialect your Looker connection is using. In Looker 21.8, the following dialects support table_compression:

Top