Skip to main content

dbt Cloud

Requirements​

warning

A Warehouse type integration must already be configured to complete the first ingestion of this integration.

info

You need to be a dbt Cloud administrator to provide the following.

Catalog Managed​

To get started with dbt Cloud in Catalog, you need to provide:

A service token

Follow the dbt guide for service tokens to generate it.

Then set up those permissions:

  • If you are on a Team plan: add Read-Only to all the relevant projects
  • If you are on an Enterprise plan: add Stakeholder to all the relevant projects

When creating a token, it can only be accessed at creation. Afterwards, it will no longer be visible. Make sure you copy it somewhere safe.

The dbt Base URL of your account

By default, https://cloud.getdbt.com will be used but depending on your region, the URL might change. See more in the dbt Cloud API documentation.

The ID of your main 'run' job in production

Among several jobs you run in production, one often actualizes all tables of your project.

On dbt Cloud, go to Deploy > Jobs and select the job that matches the description above. The ID is in the URL, right after jobs/.

You can input your API Token and job ID directly in the Catalog App integration settings.

dbt Cloud integration settings in Catalog showing Account, Username, Job ID, and Service Token fields.

For your first sync, it will take up to 48 h and we will let you know when it is complete.

Going Further​

Once your dbt Cloud integration is set up, explore more: