dbt Cloud Setup Guide Lite

Follow our setup guide to connect dbt Cloud to Fivetran.

Prerequisites

To connect dbt Cloud to Fivetran, you need a dbt Cloud account with API access. Your dbt Cloud instance must not be hosted on a Virtual Private Cloud (VPC).

TIP: You must be on the dbt Team or Enterprise plan to access the dbt Cloud API.

Setup instructions

Find API server region

1. Find your API server region in your dbt Cloud API server URL.

   • If your API server URL is https://cloud.getdbt.com, then your API server region is US region.
   • If your API server URL is https://emea.dbt.com, then your API server region is Europe region.
   • If your API server URL is https://au.dbt.com, then your API server region is AU region.
   • If your API server URL is different from the ones listed above, then your API server region is CUSTOM.

2. Make a note of the region. You will need it to configure Fivetran.

Create service token

1. Log in to your dbt Cloud account.

2. In the top right corner, click the Settings icon and then select Account Settings.

   

3. Select Service tokens.

4. Click + New Token.

5. Enter the Token Name and then click + Add to specify the project details and appropriate permissions.

   

6. In the Permission Set section, assign permissions to your service account token, depending on your plan:

   • If you are on the Team plan, select Read-only access.
   • If you are on the Enterprise plan, select Account Viewer access.

7. In the Project section, select All projects from the drop-down menu.

8. Click Save.

9. Make a note of the service token. You will need it to configure Fivetran.

Finish Fivetran configuration

1. In the connector setup form, enter the Destination schema name of your choice.

2. In the API server region drop-down menu, select the region you found in Step 1.

3. If you selected CUSTOM in the API server region drop-down menu, enter your API base URL in the Access URL field.

4. Enter the Service token you created in Step 2.

5. (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.

6. Click Save & Test. Fivetran will take it from here and sync your dbt Cloud data.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home