domains / families / data / dbt-transformation-patterns

dbt-transformation-patterns

authentic

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

When to use

• 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

When not to use

• 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

Skill page

Source