dbt-transformation-patterns

预期结果:

• Set up staging models for Stripe customers and payments with stg_ prefix
• Add an intermediate model to aggregate payments by customer using int_ prefix
• Create marts with dim_customers for dimensions and fct_orders for facts
• Add YAML tests for unique and not_null on primary keys
• Configure incremental processing for large payment tables

预期结果:

• Add not_null and unique tests on all primary key columns
• Use relationships tests to validate foreign key references
• Add accepted_values tests for categorical columns like order_status
• Use dbt_utils.expression_is_true for business rule validation
• Configure freshness checks on source definitions

预期结果:

• Incremental models process only new or changed data since last run
• Use when tables exceed 1 million rows to reduce runtime
• Configure with unique_key to identify records and incremental_strategy for update logic
• Use is_incremental() macro to filter incoming data
• Supports merge, delete+insert, and insert_overwrite strategies