Usage

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

Hierarchy

View File

view

derived_table

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 22.6, the following dialects support table_compression:

Articles in this section