- DBT
- DBT Integration
Transform DBT with Mage.
Overview
Build, run, and manage your DBT models with Mage.
| Role | Benefits |
|---|---|
| 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. |
Prerequisites
To use the DBT integration, you must run Mage using Docker.
Features
| Feature | Description |
|---|---|
| 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 | {{ env_var('...') }}{{ variables('...') }} |
| 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. |