Table of ContentsConnect Hightouch to the git repository of your dbt project and build Hightouch models using existing dbt models.At Hightouch, we use dbt to build most of our models for analytics and reporting. We've built a first class way to use dbt models as the source code for your Hightouch models. When your setup is complete, you'll be able to create Hightouch models with dbt models like this.
Navigate to your integration settings and save your git credentials. For regular username / token authentication, use your personal access token (ex: Github, Gitlab) rather than password.If you would like to scope Hightouch's access to a specific repository, we suggest you use our Github App! Make sure you select the "Github App" authentication method.Under each source, you can enable using dbt models from your git repository in Hightouch.The default schema is the schema where dbt would normally materialize your tables to unless otherwise specified in project file. Generally, this is something like
The Hightouch dbt model selector is a beta feature. Email [firstname.lastname@example.org](mailto:email@example.com) to request access or request a demo at https://hightouch.io
dbt_production.Hightouch also allows you to optionally specify dbt selectors like
tag:hightouch, but we will use
*by default and sync all dbt models to Hightouch by default.Hightouch will also automatically look for your
dbt_project.ymlfile in the repository directory. However, if your file is named something else like
dbt_project.yaml, or you have multiple
dbt_project.ymlfiles, you can specify a relative path to your project file, like
After setting up the dbt model selector, dbt models will be available in the Hightouch model creation process. Select the dbt model tab in the query explorer and view all your dbt models there!The compiled SQL shown in the preview is only used for preview purposes. When we query the warehouse, we'll be querying the table that is built by dbt.Hightouch compiles your dbt project using dbt version 0.19.0. However, we does not currently support the following features:
After saving your settings, it may take 1-2 minutes for Hightouch to sync your dbt models and for the sync status to turn green.
- Private dependency packages
- Pre / post hooks
dbt compileto resolve the schema of your data warehouse and to generate compiled SQL for preview purposes. When running the model in Hightouch, we query the materialized table directly.