dbt integration is currently only supported when using Mage in Docker.

Overview

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.

Features

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

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

Examples:

  • {{ env_var('...') }}
  • {{ variables('...') }}
  • {{ mage_secret_var('...') }}

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.

Supported connectors

  1. dbt-bigquery
  2. dbt-clickhouse
  3. dbt-core
  4. dbt-dremio
  5. dbt-duckdb
  6. dbt-mysql
  7. dbt-postgres
  8. dbt-redshift
  9. dbt-snowflake
  10. dbt-spark
  11. dbt-sqlserver
  12. dbt-synapse
  13. dbt-trino

Tutorials