- DBT Integration
Build, run, and manage your DBT models with Mage.
|Analytics engineers||With Mage and DBT combined, you can expand build and run complex data pipelines.|
|Data engineers||Simplify your data infrastructure and reduce the amount of redundant tools in your “modern” data stack. Replace DBT cloud and Airflow with Mage’s native integration with DBT.|
To use the DBT integration, you must run Mage using Docker.
|Schedule DBT model runs||Trigger your DBT model runs on a regular schedule, from an event, or via API request.|
|Run specific DBT models and their dependencies|
|Run all models and optionally exclude others|
|DBT models can depend on non-DBT related tasks||Examples:|
Build model after data ingestion from API
Build model after another pipeline completes
|Preview DBT model results as you write SQL|
|Build dynamic DBT pipelines using flexible variable interpolation|
|Automatically run DBT tests every time a pipeline runs||Write checks using DBT tests, then Mage will run them and fail the pipeline if the test results produce any failures.|
|Observability built-in||Monitor your DBT pipelines and get alerted when things break.|