Basic DBT pipeline

Basic DBT pipeline

Blocks

2

Annotated

No

Author

Mage

Updated

2/10/25

This example demonstrates how to run a dbt transformation pipeline within Mage. It covers key steps, including configuring a dbt project, running dbt models, and handling dependencies within a data pipeline.

Pipeline Overview

Step 1: Configure dbt – Define your dbt project and connect it to Mage. This includes specifying the dbt project path and ensuring dependencies are installed.

Step 2: Run dbt Models – Trigger dbt commands (dbt run, dbt test, etc.) as part of a Mage pipeline. You can run models sequentially or in parallel, depending on dependencies.

Step 3: Handle Dependencies – Chain dbt steps with other pipeline tasks, such as data ingestion or validation, to create a complete workflow.

Step 4: Monitor Execution – View logs, track performance, and debug errors using Mage’s built-in observability tools.

This example provides a practical reference for integrating dbt into a Mage pipeline, helping you automate transformations and streamline analytics workflows.

PIPELINE

PIPELINE

Useful guides

Develop dbt in Mage

Develop dbt in Mage

dbt sources and upstream dependencies

dbt sources and upstream dependencies

dbt variable interpolation

dbt variable interpolation

Running a dbt model

Running a dbt model

Serving dbt docs in production

Serving dbt docs in production

Running dbt snapshots

Running dbt snapshots