Support to set tblproperties when creating tables and views.

[manabian-]

Describe the feature

In the models config, set tblpropeties as follows.

{{ config(
  materialized='incremental', 
  tblproperties={
    'delta.autoOptimize.optimizeWrite' : 'true',
    'delta.autoOptimize.autoCompact' : 'true'
  }
) }}

There is a similar issue in spark-dbt issues, but it doesn't seem to be implemented.

dbt-labs/dbt-spark#190

Describe alternatives you've considered

There is the way to execute Alter Table statements with dbt post-hooks

Who will this benefit?

All users who create tables or views in Databricks.

As described in the following Databricks document, tblproperties settings such as delta.autoOptimize.autoCompact are often set at table creation time.

https://docs.databricks.com/delta/optimizations/auto-optimize.html