table_format parameter specifies the format that a persistent derived table (PDT) will have in an Athena database, which can be one of the following:
- Optimized Row Columnar (ORC)
- Text file
See the Amazon Athena documentation for details.
See the Dialect support for
table_formatsection below for the list of dialects that support
table_formatparameter works only with tables that are persistent, such as PDTs and aggregate tables.
table_formatis not supported for derived tables without a persistence strategy.
customer_order_facts PDT on an Amazon Athena database using ORC format:
Dialect support for
The ability to use
table_format depends on the database dialect your Looker connection is using. In Looker 21.16, the following dialects support