dbt▌

dbt unit tests validate SQL modeling logic on static inputs before materializing in production. If any unit test for a model fails, dbt will not materialize that model.

$22

Configure Astronomer Cosmos for dbt Fusion projects on Snowflake, Databricks, BigQuery, or Redshift with local execution. \n \n Requires Cosmos 1.11.0+, dbt Fusion binary installed separately in the Airflow runtime, and ExecutionMode.LOCAL with subprocess invocation \n Supports three parsing strategies: dbt_manifest (fastest for large projects), dbt_ls (for complex selectors), or automatic (simple setups) \n Covers ProfileConfig setup for warehouse connections, ProjectConfig for dbt project path

Convert dbt Core projects into Airflow DAGs or TaskGroups using Astronomer Cosmos. \n \n Supports three assembly patterns: standalone DbtDag, DbtTaskGroup within existing DAGs, and individual Cosmos operators for fine-grained control \n Choose from eight execution modes (WATCHER, LOCAL, VIRTUALENV, KUBERNETES, AIRFLOW_ASYNC, and others) based on isolation and performance needs \n Offers three parsing strategies (dbt_manifest, dbt_ls, dbt_ls_file, automatic) to balance speed and selector complexi

Core principle: Apply software engineering discipline (DRY, modularity, testing) to data transformation work through dbt's abstraction layer.

Production-ready patterns for dbt model organization, testing, documentation, and incremental processing. \n \n Implements medallion architecture with staging, intermediate, and marts layers using consistent naming conventions (stg_, int_, dim_, fct_) and materialization strategies \n Covers source definitions with freshness checks, data quality tests (unique, not_null, relationships), and comprehensive YAML documentation for lineage tracking \n Provides incremental model patterns including dele