dbt Cloud Orchestration Setup Guide Betalink
Follow our setup guide to set up integration with dbt Cloud*.
You need this integration if you want Fivetran to handle the extraction and load phases of the ELT pipeline, and dbt Cloud to handle the transformation phase.
Prerequisiteslink
To connect dbt Cloud to Fivetran, you need a dbt Cloud account with:
- API access
- at least one transformation project
NOTE: You must be on the Team or Enterprise plan to access the dbt Cloud API.
Setup Instructionslink
Find API server regionlink
Find the API server region in your dbt Cloud API server URL:
For example, if your API server URL is
https://cloud.getdbt.com
, then your API server region isUS region
. If your API server URL ishttps://emea.dbt.com
, then your API server region isEurope region
.Make a note of the region. You will need it to configure Fivetran.
Create service tokenlink
Log in to your dbt Cloud account.
In the top right corner, click the Settings icon and then select Account Settings.
Select Service tokens.
Click + New Token.
Enter the Token Name and then click + Add to specify the project details and appropriate permissions.
In the Permission Set section, assign permissions to your service account token, depending on your plan:
- If you are on the Team plan, select Member access.
- If you are on the Enterprise plan, select Developer access.
In the Project section, select All projects from the drop-down menu.
Click Save.
Make a note of the service token. You will need it to configure Fivetran.
TIP: For more details about service account tokens, read the dbt Cloud documentation.
Finish Fivetran configurationlink
Open the transformation setup form
From the Region drop-down, select the region you found.
If you are using Virtual Private dbt or Single Tenant deployment, you can change Access URL and Discovery API URL. Set the Change Access and Discovery API URL toggle to ON and enter the Access URL and Discovery API URL.
Click Authenticate.
After successful authentication, the Account drop-down appears in the setup form. From the list, select your dbt Cloud.
After Fivetran receives the account projects, the Project drop-down appears in the setup form. From the list, select the project you want to use for the integration.
Click Save & Test. Fivetran will take it from here and create the integration with dbt Cloud.
* dbt Cloud is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
Related articleslink
description dbt Orchestration Overview