Support for table properties

[wrb2]

When creating a table in Presto or Trino, you can define table properties (example from docs):

CREATE TABLE hive.web.page_views (
  view_time timestamp,
  user_id bigint,
  page_url varchar,
  ds date,
  country varchar
)
WITH (
  format = 'ORC',
  partitioned_by = ARRAY['ds', 'country'],
  bucketed_by = ARRAY['user_id'],
  bucket_count = 50
)

It would be helpful to be able to define those for table models, similar to how you can configure distkey and sortkey in dbt-redshift.

{{
config(materialized='table',
       partitioned_by=['ds', 'country'],
       format='ORC',
       bucketed_by='user_id',
       bucket_count=50)
}}

It would allow the users to define storage formats, partitioning and similar. Since different Presto connectors use different properties, this option should be generic and allow any properties.

[wrb2]

This is also implemented already in dbt-athena .