dbt-transformation-patterns

Create a dbt staging model for the [source_name] [table_name] table. Include source definition with column descriptions, a staging SQL model with proper renaming conventions, and basic tests for primary key and not-null constraints.

Create a dbt incremental fact table model named fct_[name] that tracks [business_process]. Configure it for incremental materialization with [strategy], define the unique_key, and include the incremental filter logic using is_incremental().

Review this dbt model SQL and generate the corresponding YAML documentation file. Include model description, column descriptions, and appropriate tests (unique, not_null, relationships, accepted_values) based on the columns present.

Design a dbt model structure for a [domain] analytics workflow. Define the staging models needed for [sources], intermediate models for business logic, and mart models (dimensions and facts) for final output. Include naming conventions and materialization strategies for each layer.