dbt Transformation Patterns

Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.

Use this skill when

• Building data transformation pipelines with dbt
• Organizing models into staging, intermediate, and marts layers
• Implementing data quality tests and documentation
• Creating incremental models for large datasets
• Setting up dbt project structure and conventions

Do not use this skill when

• The project is not using dbt or a warehouse-backed workflow
• You only need ad-hoc SQL queries
• There is no access to source data or schemas

Instructions