yml2ddl

Convert Starlake YML definitions into SQL DDL statements.

209|30|Updated Sep 18, 2021
One-click install
npx skills add https://github.com/starlake-ai/starlake --skill yml2ddl
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: yml2ddl
Source: https://github.com/starlake-ai/starlake/tree/main/.agent/skills/yml2ddl
Command: npx skills add https://github.com/starlake-ai/starlake --skill yml2ddl

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Converts Starlake YML definitions into SQL DDL statements to automate schema creation and deployment, reducing manual SQL coding and errors.

Core Features & Use Cases

  • Generate DDL for specified datawarehouse, domain, and schemas based on YAML inputs.
  • Validate and convert YAML-driven schemas into executable DDL, supporting catalog and output path options.
  • Use Case: Deploy a set of YML-defined schemas to Snowflake with a single command, ensuring consistency across environments.

Quick Start

Run starlake yml2ddl --datawarehouse <name> --domain <domain> to generate DDL from your YAML definitions.

Frequently Asked Questions about yml2ddl

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

FAQPage Schema
How do I generate SQL DDL from YAML schema definitions?

To generate SQL DDL from YAML schema definitions, use a conversion tool that parses YAML inputs and outputs executable DDL statements. This automates schema creation by translating YAML-driven schemas into SQL for specified data warehouses, domains, and catalogs.

What is the best way to automate data warehouse schema creation from YAML files?

Automating data warehouse schema creation from YAML files is best achieved by generating SQL DDL statements directly from the definitions. This approach parses YAML inputs and deploys executable DDL, reducing manual SQL coding and ensuring consistency across multiple environments.

Can I deploy YML-defined schemas to Snowflake automatically?

Yes, you can deploy YML-defined schemas to Snowflake automatically by converting the YAML definitions into SQL DDL. By specifying the data warehouse and domain, the tool generates the necessary DDL to deploy schemas with a single command.

How do I validate and convert YAML schemas into executable DDL for multiple domains?

To validate and convert YAML schemas into executable DDL for multiple domains, run a conversion command specifying the target data warehouse and domain. The tool parses the YAML inputs, validates the schema structure, and generates DDL for the specified domains.

Does YML to DDL generation support custom output paths and catalogs?

Yes, YML to DDL generation supports custom output paths and catalogs. When converting YAML definitions into SQL DDL statements, you can specify options for the output path and catalog to organize and deploy the generated schema files.