skills.rest
databricks-solutions
databricks-solutionsOFFICIAL
Explore all skills by this author →
GitHub

01-yaml-table-setup

Generate Databricks Unity Catalog Gold layer tables from YAML schema definitions.

5|6|Updated Jan 26, 2026
Search Tags:#automation#data modeling#databricks#table creation#gold layer#yaml schema
One-click install
npx skills add https://github.com/databricks-solutions/vibe-coding-workshop-template --skill 01-yaml-table-setup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: 01-yaml-table-setup
Source: https://github.com/databricks-solutions/vibe-coding-workshop-template/tree/main/data_product_accelerator/skills/gold/pipeline-workers/01-yaml-table-setup
Command: npx skills add https://github.com/databricks-solutions/vibe-coding-workshop-template --skill 01-yaml-table-setup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyyaml, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the creation of Gold layer tables by reading schema definitions from YAML files, eliminating the need for manual SQL DDL or embedded strings in Python code.

Core Features & Use Cases

  • YAML-Driven Schema: Define table structures, primary keys, and column properties in a centralized YAML format.
  • Dynamic Table Creation: A single Python script generates and executes CREATE TABLE statements at runtime.
  • Use Case: When managing a large number of Gold layer tables across multiple domains with frequent schema changes, this Skill allows for rapid updates and consistent table definitions by simply editing YAML files.

Quick Start

Use the 01-yaml-table-setup skill to create Gold layer tables by pointing it to your YAML schema definitions.

Frequently Asked Questions about 01-yaml-table-setup

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

FAQPage Schema
How do I automate creating Gold layer tables in Databricks from YAML?▼

Automate Gold layer table creation in Databricks by defining schemas in YAML files and running a Python script to dynamically generate and execute CREATE TABLE statements in Unity Catalog.

What is the best way to manage frequent schema changes for multiple Databricks tables?▼

Manage frequent Databricks table schema changes declaratively by editing centralized YAML files for table names, primary keys, and Delta Lake TBLPROPERTIES, ensuring consistent definitions across multiple domains.

Can I define primary keys and Delta Lake TBLPROPERTIES using YAML schema definitions?▼

Yes, YAML schema definitions support specifying primary keys, column types, nullability, and standard Delta Lake TBLPROPERTIES to dynamically create Unity Catalog tables with full schema consistency.

Do I need Databricks Asset Bundles to orchestrate dynamic table creation?▼

Yes, this Skill orchestrates dynamic table creation via Databricks Asset Bundles and Python scripts, requiring the pyyaml dependency to parse schema definitions and generate tables in Unity Catalog.

Why use YAML files for Gold layer table creation instead of manual SQL DDL?▼

Use YAML files for Gold layer table creation to eliminate manual SQL DDL or embedded Python strings, allowing rapid updates and centralized manageability for numerous tables with evolving requirements.

Related Skills

Explore More Data & Analytics Skills→
prashsubprashsub
1

01-yaml-table-setup

Create Gold layer tables from YAML schema definitions using Python scripts.

Community
Advanced
PaldomPaldom
11

databricks-zerobus-ingest

Ingest data into Databricks Delta tables via gRPC with retry logic.

Community
Advanced
prashsubprashsub
1

bronze-layer-setup

Automate Bronze layer table setup with DDLs, Faker data, and Databricks Asset Bundle jobs.

Community
Advanced
databricks-solutionsdatabricks-solutions
5

gold-layer-setup

Create Databricks Gold layer tables from YAML schema definitions.

Official
Intermediate