databricks-table-properties

Required TBLPROPERTIES for Delta tables vary by medallion layer to ensure governance compliance. Bronze, Silver, and Gold layers each require specific metadata tags, auto-optimize settings, and mandatory CLUSTER BY AUTO configuration for performance optimization.

To enable Change Data Feed (CDF) on Unity Catalog Delta tables, you must set the appropriate TBLPROPERTIES during table creation. This Skill provides the standard CDF enablement patterns required for tracking row-level changes across medallion layers.

Standardizing table and column comments for PII data classification involves applying consistent metadata tagging patterns. This Skill provides domain values, data classification tags, and comment standards to ensure proper governance and discoverability in Unity Catalog.

Setting CLUSTER BY AUTO improves query performance on Databricks Delta tables by optimizing data layout. This Skill enforces mandatory CLUSTER BY AUTO configuration for all table creation operations to ensure optimal performance across medallion layers.

You can use this Skill to apply auto-optimize settings across Bronze, Silver, and Gold layers. It provides standard TBLPROPERTIES and validation checklists to ensure consistent performance optimization and governance metadata for all Delta table operations.

Databricks Delta tables fail governance compliance checks without standard metadata due to missing ownership, PII tags, or inconsistent properties. This Skill provides validation checklists and required TBLPROPERTIES to ensure compliance across medallion layers.