table_compression parameter specifies the compression that a persistent derived table (PDT) will have in an Athena database, either
See the Amazon Athena documentation for details.
See the Dialect Support for
table_compressionsection below for the list of dialects that support
table_compressionparameter works only with tables that are persistent, such as PDTs and aggregate tables.
table_compressionis not supported for derived tables without a persistence strategy.
customer_order_facts PDT on an Amazon Athena database with SNAPPY compression:
Dialect support for
The ability to use
table_compression depends on the database dialect your Looker connection is using. In Looker 21.16, the following dialects support