To schedule syncs via dbt Cloud, dbt requires you to have a paid plan.
The dbt Cloud extension lets you schedule Hightouch syncs to run as soon as a dbt Cloud job completes. Relying on dbt Cloud for sync scheduling ensures that Hightouch performs syncs when fresh data is available.
Extension setup requires two steps:
- Connecting your dbt account to Hightouch
- Configuring your Hightouch sync to follow a dbt Cloud job
Connect to dbt Cloud
Open the dbt Cloud configuration page in your workspace and enter the dbt Cloud URL. Depending on your setup, you need to insert:
- for regular dbt Cloud setups, a default access URL
- for accounts with cell-based account prefixes, you can find the custom unique access URL in dbt on the Account settings page (below the Account information pane)
These are the most commonly used default access URLs:
https://cloud.getdbt.com, for the UShttps://emea.getdbt.com, for EMEA
Then navigate to dbt Cloud and generate a personal access token (PAT) or a service account token. In Hightouch, enter your token in the dbt Cloud API token field in the Configuration tab of the dbt Cloud extension. Click Connect to complete your connection configuration.
A read-only service account token is sufficient for this integration.
If you want to update your dbt Cloud API token in Hightouch, you can disconnect the extension and reconnect it using the new API token. This won't reset the schedule configuration of syncs that use the dbt Cloud scheduling method.
Configure your sync schedule
Now, when creating or modifying a sync you can select dbt Cloud as a schedule type.
- Go the Schedule tab of overview page of the sync you want to schedule. Select dbt Cloud as the schedule type.
- Select the appropriate dbt Account and Job.
- Click Save.
Your sync is now scheduled to run whenever your chosen dbt Cloud jobs complete.
The sync won't be triggered if your dbt Cloud job fails.