
What is Mage’s dbt Integration?
Mage is a modern data pipeline tool that lets you build, schedule, and monitor dbt models alongside your data workflows — all in one platform. With Mage, you can fully automate your dbt workflows without using Airflow or dbt Cloud.
Who Should Use dbt in Mage?
Mage’s dbt integration is designed for both analytics engineers and data engineers who want more control, flexibility, and observability in their data workflows.Analytics engineers
If you’re transforming raw data into clean, analytics-ready datasets using dbt, Mage helps you:- A visual interface to build and run dbt models
- The ability to chain dbt steps with Python or SQL blocks
- Easy scheduling and triggering for model runs
- Live SQL previews to speed up development
Data engineers
If you’re building and orchestrating production-grade data pipelines, Mage lets you:- Run dbt models as part of larger end-to-end workflows
- Replace complex orchestration tools like Airflow
- Run dbt across environments — including Docker, Kubernetes, Mage Pro, or in the cloud (AWS, GCP, Azure)
- Monitor, debug, and get alerts on dbt runs with built-in observability tools
Key Features
Schedule dbt model runs
Set dbt models to run:- On a schedule
- When a file or event triggers
- From an API call or upstream task
Run specific dbt models and their dependencies

- Select and run individual dbt models
- Automatically include required dependencies
Exclude Models When Running All

Chain dbt Models with Other Tasks
Build workflows where dbt models run after:- Pulling data from APIs
- Completing a Python or SQL block
- Finishing a different pipeline
Preview dbt model results as you write SQL

Build dynamic dbt pipelines using flexible variable interpolation
Take advantage of dynamic variable interpolation like:{{ env_var('...') }}
{{ variables('...') }}
{{ mage_secret_var('...') }}
Automatically run dbt tests every time a pipeline runs
Mage will:- Detect and run your dbt tests during each pipeline run
- Fail the pipeline if any dbt test fails
Built-In Monitoring and Alerting
Mage gives you full observability into your dbt runs:- Track model run history
- See logs and SQL output
- Get alerts when models fail
Supported connectors
dbt-bigquery
dbt-clickhouse
dbt-core
dbt-dremio
dbt-duckdb
dbt-mysql
dbt-postgres
dbt-redshift
dbt-snowflake
dbt-spark
dbt-sqlserver
dbt-synapse
dbt-trino