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
Navigate to dbt Cloud and retrieve your API Key.
In Hightouch, enter your API Key in the dbt Cloud configuration page
Optionally, enter a custom subdomain.
If the subdomain is left empty, Hightouch defaults to "cloud."
If you have an EMEA dbt instance, you should enter emea for the subdomain.
Click Connect to complete your connection configuration.
If you want to update your dbt Cloud API key in Hightouch, you can disconnect the extension and reconnect it using the new API key. 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.