Skip to main content
Log in

Integrations

Introducing dbt Exposures for Hightouch

Get end-to-end visibility for how your data is flowing between dbt and Hightouch.

Hugo Darwood

August 2, 2022

4 minutes

Introducing dbt Exposures for Hightouch.

When building your team’s data pipelines, it can be difficult to have visibility into how your tables and data are used downstream. This lack of visibility can lead to unintentional breaking changes, wasted time as you try to maintain unused tables and frustration as you try to piece together which syncs are associated with certain tables. dbt recently launched a new feature called Exposures to give you a way to express the downstream utilization of your sources and models in data docs and lineage graphs.

We’re excited to announce that Hightouch now supports dbt Exposures natively in our app. With a simple toggle switch, you can automatically update your dbt repos with Exposures to see where models are being used in your team’s Hightouch syncs. This means better end-to-end visibility of your data lineages, giving you clearer context for how data moves through your pipelines so you can avoid breaking changes.

🎥 Check out this video for a quick demo of how it works.

image (1).png

dbt Exposures

dbt + Hightouch = ❤️

dbt continues to take the data world by storm, with no signs of stopping. This launch further deepens our integration with the popular data transformation tool, making it easier than ever for our customers to use the warehouse as their single source of truth for Data Activation. By enabling our dbt integration, you can:

  • Pull existing dbt models via git and sync modeled data directly from the warehouse to 100+ business tools
  • Trigger Hightouch syncs to execute after dbt Cloud jobs run
  • Get complete context for how Hightouch syncs are related to dbt models

If you’re new to dbt (we’ve been there!), we recently wrote a primer on dbt with some simple tips on how you can jumpstart your knowledge.

Analytics Engineers are responsible for building and delivering data assets that increasingly power business operations in addition to reporting. With the Hightouch dbt Exposures integration, dbt users can easily visualize their data lineage and understand how their dbt models and Hightouch syncs interact. We are pleased that Hightouch continues to build deep integrations into dbt, making it easier than ever for our joint customers to power workflows off their dbt modeled data.

Nikhil KothariHead of Technology Partnerships at dbt Labs

Setting up dbt Exposures in Hightouch

To activate dbt Exposures in Hightouch, head to the Extensions tab and select the dbt-compatible source you want to set up. If you have not yet activated dbt model sync for your source, you should do so now. Enable the toggle for dbt Exposures Sync, which will create commits in your dbt repo to create the Hightouch exposures file (just make sure Hightouch has write access to your dbt branch).

extensions (1).png

Hightouch Extensions

exposures-commit.png

Exposures Commit

Once you have enabled dbt Exposures, you should see the sync status indicator turn green and a commit created in your dbt repo. dbt Exposure syncs will run whenever there are changes to a Hightouch sync that use a dbt model.

dbt exposures sync.png

dbt Exposures Sync

If Hightouch encounters an error updating your dbt Exposures, you can see the error details under the “activation toggle,” helping you debug faster.

dbt-error.png

Error Details

Now, when you rebuild your lineage graphs in dbt on your latest commit, you’ll be able to see exactly which Hightouch syncs are using your dbt models.

Anytime a Hightouch sync is created or updated that uses one of your dbt models, Hightouch will update the Exposures file in your dbt repo, showing you your updated Exposures when you next rebuild your dbt docs. You can also quickly visualize where you need to run your DAG up to to ensure your Hightouch syncs are using the freshest data.

Looking Ahead

In the next few months, we will continue to invest in our dbt integration to further surface the connection between your dbt models and your downstream data flows. We want to help you ship changes to dbt models with confidence by providing better validation and simulations of the impact radius on all dependent syncs.

We’re also working closely with our partners in data observability to better flag when changes upstream can impact Hightouch syncs. Check out our recent integration with Datafold to learn more.

Get Started

dbt Exposures for Hightouch is GA for all Hightouch customers. Simply navigate to the Extensions tab, click the dbt Models tile, and toggle the dbt Exposures button to “Enable.” Check out our Docs to learn more. We’ll also be at dbt Coalesce October 17-21 in New Orleans…hope to see you there!

More on the blog

  • What is Reverse ETL? The Definitive Guide .

    What is Reverse ETL? The Definitive Guide

    Learn everything there is to know about Reverse ETL, how it fits into the modern data stack, and why it's different than ETL.

  • The CDP As We Know It Is Dead: Introducing the Composable CDP.

    The CDP As We Know It Is Dead: Introducing the Composable CDP

    Learn why CDPs are dead and how you can take advantage of the data warehouse.

  • What is Data Activation?.

    What is Data Activation?

    Learn everything to know about Data Activation, what it is, why it matters, and how you can get started activating your data today.

Table of contents

dbt + Hightouch = ❤️Setting up dbt Exposures in HightouchLooking AheadGet Started

Share

Sign up for our newsletter

Ready to activate your data?

Get startedBook a demo