dbt Model Generator

СреднийdataМинимальный контекст: 16K

Generates and refactors dbt models for analytics engineering. Writes staging, intermediate, and mart models following layered conventions, adds schema.yml tests and descriptions, applies incremental and materialization strategies, and structures sources and refs correctly. Produces SQL plus YAML that fits dbt best practices and is ready to run.

dbtanalytics-engineeringsqldata-modelingtransformation

Варианты использования

  • Scaffolding staging, intermediate, and mart models
  • Adding schema.yml tests and column descriptions
  • Converting ad-hoc SQL into layered dbt models
  • Applying incremental materialization to large tables

Пример промпта

Generate dbt models for an orders pipeline.

Sources: raw.orders, raw.customers (Snowflake)
Goal: a fct_orders mart with customer attributes and daily order metrics.

Deliver:
1. stg_orders and stg_customers staging models with light cleaning
2. An int_ model joining them if needed
3. fct_orders mart (consider incremental materialization; explain the choice)
4. schema.yml with not_null/unique/relationships tests and descriptions
Follow standard dbt layering and use ref()/source() correctly.

Рекомендуемые модели

claude-opus-4-6gpt-5deepseek-v4qwen3-coder

Совместимые инструменты

claude-codecursorkiroany

Модальности

Вход: text, code
→
Выход: text, code

Похожие Skills

sql-generationdata-pipeline-builderdata-contract-designer

Автор

OpenModels Community

@openmodelsrun