Welcome to the dbt system setup guide!
In this article we'll cover the following:
Authenticating dbt in Savant
Setting up Post-Action Triggers
Authenticating dbt in Savant
To integrate dbt with Savant, you need to provide Savant an API Key and Account ID.
To retrieve your API Key: In dbt, navigate to Settings > Profile Setting > Your Profile > Access API > API key.
To retrieve your Account ID: In dbt, navigate to Settings > Account Settings and get the suffix of the URL from Account Settings. It is in the following format: https://cloud.getdbt.com/settings/accounts/{account_id}.
Once you've acquired your API Key and Account ID from dbt, you're ready to authenticate in Savant.
In Savant, navigate to Data-> Systems-> New System and select dbt
Enter your API Key and Account ID into the appropriate fields and hit "Authenticate"
3. After authenticating, you'll be prompted to give the system a name. Do so and hit save. You've now successfully authenticated dbt in Savant.
Setting up post-action triggers
Post-action triggers allow you to automatically execute a dbt model after the completion of a Savant job. This is a valuable feature when you are using Savant to replicate data from a system into Snowflake, and want to run dbt models after the data is refreshed.
dbt post action triggers are configured in the Snowflake destination node.
When configuring your Snowflake destination, click "+" under Post Action
Select "Trigger dbt Jobs"
Select the dbt System (authentication) you created in the authentication step above.
Select the dbt model you wish to execute on completion of the Savant bot.
Click "Appy" to save your configuration.
Watch the following video to see the configuration in action.
