table_compression

Usage

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

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 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 the latest release of Looker, the following dialects support table_compression: