dbt-model-generator

name

dbt-model-generator

description

Automatically generate dbt dimensional models from raw Snowflake tables. Use when: user wants to generate dbt models, shift left data modeling, automate dimensional modeling, create facts and dimensions from raw data, build a star schema from raw tables, or auto-generate dbt code. Triggers: generate dbt models, shift left, dimensional model, auto model, star schema from raw, dbt from iceberg, dbt from raw, one big table, OBT, wide table.

dbt Model Generator

Automates the creation of dbt models from raw Snowflake tables. Profiles the data, recommends a modeling pattern (star schema, OBT, or wide denormalized), generates staging/dim/fact models with tests, and submits a PR for engineer review.

Requirements

• dbt: dbt-core>=1.7,<2.0 with dbt-snowflake>=1.7,<2.0
• Python: 3.9+
• Runtime: uv (preferred), pipx, or pip — skill auto-detects what's available
• Git: git CLI + gh CLI for PR creation
• Snowflake: Active CoCo connection or environment-variable-based auth

Workflow

Start
  ↓
Step 1: Collect Parameters
  ↓
Step 2: Discover & Profile Raw Tables
  ↓
Step 3: Recommend Modeling Pattern
  ↓  ⚠️ STOP — User approves pattern + classification
Step 4: Generate dbt Project Scaffold
  ↓
Step 5: Generate Models (staging → dims → facts / OBT)
  ↓
Step 6: Generate Schema Tests & Docs
  ↓
Step 7: Validate (dbt parse + optional dbt run)
  ↓  ⚠️ STOP — User reviews generated models
Step 8: Git Commit & PR
  ↓
Done

Parameters

Required:

• <SOURCE_DATABASE>: Snowflake database containing raw tables
• <SOURCE_SCHEMA>: Schema within the database (or * for all schemas)

Optional:

• <SOURCE_TABLE>: Specific table to model (default: discover all tables in schema)
• <PROJECT_NAME>: dbt project name (default: derived from database name)
• <PROJECT_PATH>: Where to create the project on disk (default: ~/Documents/coco-dev/<PROJECT_NAME>)
• <GITHUB_REPO>: GitHub repo for PR (format: owner/repo-name)
• <WAREHOUSE>: Snowflake warehouse (default: use active CoCo connection's warehouse)
• <ROLE>: Snowflake role (default: use active CoCo connection's role)

Full step-by-step detail, SQL queries, dbt templates, column classification rules, and troubleshooting in references/workflow.md.