Table Properties
Specifies the table properties to be used for creating tables in Databricks using the CREATE TABLE statement.
The value is appended to the generated CREATE TABLE statements as the TBLPROPERTIES clause. The default enables Delta auto-optimization (optimizeWrite and autoCompact). An object's own Databricks Table Properties value, when set in the object metadata, overrides this setting for that object.
When to Change This Setting
Keep the default for automatic file compaction on write. Change it when tables need different Delta properties as a standard — the value is used as written, so it must be a complete TBLPROPERTIES (...) clause.
Related Settings
| Setting | Interaction |
|---|---|
| Optimize Table | Explicit post-load compaction, as opposed to the default auto-optimization properties |
| Use Liquid Clustering | Adds clustering to the created tables alongside these properties |
Notes
- This setting is part of the Databricks settings category.
- The default value for this setting is
TBLPROPERTIES (delta.autoOptimize.optimizeWrite = true, delta.autoOptimize.autoCompact = true).