skills.rest
prashsub
prashsubCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

databricks-table-properties

Enforce standard TBLPROPERTIES and metadata patterns for Unity Catalog Delta tables.

1|Updated Jan 22, 2026
Search Tags:#metadata#governance#clustering#databricks#unity catalog#delta lake#table properties
One-click install
npx skills add https://github.com/prashsub/vibe_coding_lakehouse_starter_repo --skill databricks-table-properties-prashsub
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-table-properties
Source: https://github.com/prashsub/vibe_coding_lakehouse_starter_repo/tree/main/data_product_accelerator/skills/common/databricks-table-properties
Command: npx skills add https://github.com/prashsub/vibe_coding_lakehouse_starter_repo --skill databricks-table-properties-prashsub

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes assets (resource) components.

What problem does it solve?

This Skill ensures all Databricks Delta tables across Bronze, Silver, and Gold layers adhere to consistent naming conventions, property settings, and metadata standards, crucial for governance, compliance, and efficient data management.

Core Features & Use Cases

  • Standardized TBLPROPERTIES: Provides and enforces required table properties for each medallion layer (Bronze, Silver, Gold).
  • Clustering Configuration: Mandates the use of CLUSTER BY AUTO for optimal performance.
  • Metadata Tagging: Guides on essential metadata like domain, entity_type, contains_pii, and data_classification.
  • Comment Standards: Defines patterns for table and column comments, including dual-purpose formats for Gold layer tables.
  • Use Case: When creating a new 'customer' dimension table in the Silver layer, use this Skill to ensure it includes delta.enableChangeDataFeed, layer='silver', domain='retail', entity_type='dimension', and is configured with CLUSTER BY AUTO.

Quick Start

Apply the standard Databricks table properties for a new Bronze layer table named 'bronze_orders' with domain 'sales' and entity_type 'fact'.

Frequently Asked Questions about databricks-table-properties

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What TBLPROPERTIES are required for Databricks Delta tables in the Bronze, Silver, and Gold layers?▼

Required Databricks Delta table TBLPROPERTIES vary by medallion layer but generally include layer identifiers, domain values, entity types, and data classification tags to ensure governance compliance and metadata consistency across Bronze, Silver, and Gold.

How do I configure Change Data Feed and auto-optimize for a Unity Catalog Delta table?▼

To configure Change Data Feed and auto-optimize for a Unity Catalog Delta table, you enable delta.enableChangeDataFeed and set auto-optimize properties within the TBLPROPERTIES clause during table creation to ensure performance optimization and tracking.

When should I use CLUSTER BY AUTO for Delta table creation in Databricks?▼

You should use CLUSTER BY AUTO for Delta table creation in Databricks whenever you are setting up tables across Bronze, Silver, or Gold layers, as it is a mandated configuration for optimal performance and data skipping.

Does this metadata standardization approach work with existing Unity Catalog tables?▼

Yes, the metadata standardization approach applies to Unity Catalog Delta tables, enforcing required TBLPROPERTIES, metadata tagging, and comment patterns across existing and new tables to maintain governance compliance.

What is the best way to standardize table and column comments for Gold layer Delta tables?▼

The best way to standardize table and column comments for Gold layer Delta tables is to follow defined dual-purpose comment patterns that ensure proper metadata tagging and clear documentation for downstream consumption.

Why do I need to set data classification tags like contains_pii on my Databricks tables?▼

You need to set data classification tags like contains_pii on Databricks tables to enforce governance compliance, ensure proper metadata tagging, and maintain consistent security standards across all medallion layers.

Related Skills

Explore More Data & Analytics Skills→
databricks-solutionsdatabricks-solutions
5

databricks-table-properties

Generate standard TBLPROPERTIES and metadata patterns for Unity Catalog Delta tables.

Official
Intermediate
tja688tja688

unity-catalog-tagger

Apply and manage Unity Catalog metadata tags for tables, columns, and schemas.

Community
Advanced
m19cm19c

databricks-metric-views

Automate governed business metric views in Databricks using YAML definitions.

Community
Advanced
databricks-solutionsdatabricks-solutions
5

gold-layer-setup

Create Databricks Gold layer tables from YAML schema definitions.

Official
Intermediate