dbt and Hightouch are Putting Your Transformed Data to Work

Give your business teams access to transformed data in the tools they use every day. Hightouch now integrates with dbt to help you bring “Reverse ETL” to your stack.

By Azzam Aijazi and Alexis Jones on January 27th, 2022Data

dbt + Hightouch

Hightouch integrates natively with dbt, allowing you to pull your existing dbt models via git and send modeled data from your warehouse to over 60 different tools. Combined, dbt and Hightouch bridge the gap between data and business teams to enable everyone to use modeled data however they need.

(Yes, even you, Bob. You’re welcome, Bob.)

dbt image 3.png

With dbt’s collaboration, deployment, and testing functionality, you can create robust models that drive business value such as propensity scores, lead scores, customer health scores, ARR/MRR, funnel stages, and more. Then, by simply triggering a Hightouch sync after your dbt Cloud job, you can send modeled data to:

  • CRM systems such as Salesforce, Hubspot, and Pipedrive to better understand customer acquisition
  • Marketing automation platforms such as Pardot, Marketo, and Omnisend to deliver personalized marketing campaigns
  • Customer Support and Success Helpdesk solutions like Zendesk, Gainsight, and Totango to pre-emptively identify and reduce churn
  • Workflow tools like Slack and Asana to automate internal ops processes

dbt image 4.png

You might already be doing some of this in-house using a complex web of scripts and API calls, but a tool like Hightouch takes out all the tedious work, freeing up your data engineering resources to focus on the infrastructure work where they add the most value.

William Tsu on Blend’s Customer Success Operations team had this to say:

We use dbt to model data from various sources in our warehouse. Specifically, dbt allows us to codify and version control all the business logic that determines our company's key metrics (eg: Annual Run Rate, Customer Counts, Feature Adoption, etc.). Hightouch is then used to pipe this data out to the relevant stakeholders. This makes sure that everyone at Blend is using the same methodology when it comes to analytics.

Putting Your Data to Work

Here's what you can do today with Hightouch's native integration with dbt Cloud:

  • Schedule Syncs after dbt Cloud jobs: You can now put your data into action as soon as it’s been modeled by scheduling a Sync to execute after your dbt Cloud job runs. This ensures that Hightouch always performs Syncs with fresh data. All you need to do is connect your account using the dbt Cloud API, and select the job you want a Sync to run after.

dbt image 5.png

  • Select dbt models to sync, version-controlled through git. Hightouch’s dbt Model Selector allows you to pull your existing dbt models via git and send data to over 60 destinations. That way, whenever you update your dbt models, Hightouch automatically reflects those changes in your Syncs.

dbt image 6.png

  • Visually filter modeled data through an easy-to-use UI. This provides a clear hand-off between data and business teams. Data teams own the modeling of data (using tools like dbt) and then business teams own how that modeled data should appear in their tools. The crux? This means that business teams can now ✨ self-serve ✨ data pipelines into their own tools.

audiences.png

  • Visualize dependencies between dbt models and downstream Hightouch syncs. With our native dbt Exposures integration, you can build context for your end-to-end data lineages to better understand how data moves through your pipeline so you can avoid accidental breaking changes. You can get started right away with a simple toggle switch in our app.

image of dbt exposures

And if you'd prefer to watch this in action instead of read about it, then fret not. You're in good hands: Watch Now >>>

The Future of dbt and Hightouch

Our friends over at Hightouch are pretty committed to the idea that data teams and business teams should be able to do everything in the tools they are most comfortable with. While today you can trigger Syncs after dbt Cloud jobs from within Hightouch, in the near future, they want to allow teams to create entire Hightouch Syncs within dbt Cloud itself.

In fact, Hightouch just moved one step closer to this dream by enabling users to configure Syncs through creating or editing JSON objects directly (which will be doable through dbt Cloud or the dbt CLI soon).

Getting Started with dbt + Hightouch

If you’re interested in getting your Reverse ETL on with dbt and Hightouch, check out the Hightouch website and docs to get started today. And if, along the way, you need a little help or just want a place to share your excitement, don’t forget to chime in on #tools-hightouch or #operational-analytics on Slack.

It's time to set your data free. After all, how would you like to be stuck in a warehouse all day?

Sign up for more articles like this

Ready to leverage your customer data?

Hightouch logo

Your data warehouse is your source of truth for customer data. Hightouch syncs this data to the tools that your business teams rely on.

Copyright © 2022 Carry Technologies, Inc. dba Hightouch.
All rights reserved.

501 Folsom St3rd FloorSan Francisco, CA 94105United States