dbt Cloud

dbt is a data transformation tool that enables data analysts and engineers to transform, test and document data in the cloud data warehouse.

Metaplane can access your dbt cloud metadata to extract metadata about job runs metadata such as run durations, models generated by dbt, and lineage relationships between models. Metaplane is able to match tables in your warehouse with dbt models to determine the causality and consequences of table failure.

🚧

Paid dbt plans only

The dbt Cloud API is only available to Team and Enterprise customers.

🚧

Team Owners only

To obtain a dbt Cloud API Token, you must be an owner on the team. You can send your dbt team owner this doc for them to complete as well.

Enabling API access

  1. Navigate to dbt Cloud: https://cloud.getdbt.com

  2. Click on the top left hamburger menu button > Account Settings

  1. Click the button Enable Metadata Access

Retrieving API key

  1. Click on your profile icon > Profile
  1. Click API Access
  1. Copy API Key

Add API Key to Metaplane

  1. Navigate to https://app.metaplane.dev/settings
  2. Click on the dbt button
  1. Add the dbt API token into the modal and save

The historical run time data for dbt jobs will immediately start syncing. You can see these jobs by clicking on the "jobs" navigation tab, or going to https://app.metaplane.dev/jobs.

Downstream/upstream lineage from dbt will be available within tests and alerts within 24 hours.


Did this page help you?