Scheduling with dbt Cloud

The Hightouch dbt Cloud integration allows you to schedule a query to execute after your dbt job runs. This ensures that Hightouch always performs syncs with fresh data.

This requires two steps:

  • Connecting your dbt account to Hightouch

  • Configuring your query to follow a dbt job

Connecting to dbt

Navigate to dbt Cloud and retrieve your API Key.

Then copy your API Key from dbt Cloud to the Hightouch credential page.

Configuring your query

Now when creating a query you will be able to select dbt as a schedule type.

You can also change the schedule type of an existing query by selecting "Query settings" from the query page.

Just select which dbt account and job that your query will run after.

Now when your dbt job runs Hightouch will subsequently trigger your query!