Skip to main content
dbt (data build tool) is the standard for data transformation in modern data stacks. The Cargo integration allows you to pull data from your dbt models directly into Cargo data models.

​
Authentication

Connect to dbt Cloud using your API token and account details.

​
Connection details

FieldDescription
API TokenYour dbt Cloud API token
AccountYour dbt account
EnvironmentYour dbt environment
Generate your API token in dbt Cloud under Account Settings → API Access.

​
Data models

​
Fetch model

Pull data from a dbt model into a Cargo data model. Configuration
FieldDescription
ModelSelect the dbt model to sync
IDColumn containing unique record IDs
TitleColumn containing record display titles
Cargo dynamically loads available models and columns from your dbt environment.

​
Use cases

Use dbt-transformed data as the source for your Cargo workflows.
Pull calculated metrics and aggregations from dbt models.
Leverage dbt’s tested and documented models for reliable data.

​
Best practices

  1. Use production environment - Connect to your production dbt environment for stable, tested data
  2. Set proper ID columns - Choose columns that uniquely identify each record
  3. Document your models - dbt model descriptions appear in Cargo’s model selector