Currently, the DDL is used in very basic. We have a very large use case and in some cases we are forced to use Views which can be slow. Databricks is requesting we add performance improvements, which require a DDL change.

I would like a check box or something similar that allows for the following on those bronze tables.

1) Z order and bin packing: https://docs.databricks.com/en/sql/language-manual/delta-optimize.html

2) partitioning https://docs.databricks.com/en/sql/language-manual/sql-ref-partition.html

3) liquid clustering: https://docs.databricks.com/en/delta/clustering.html

4) predictive optimizations: https://docs.databricks.com/en/optimizations/predictive-optimization.html