Usage
derived_table: {
table_compression: GZIP
…
}
}
Hierarchytable_compression |
Default ValueGZIP AcceptsGZIP or SNAPPY Special Rulestable_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 supporttable_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:
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
: