Putting your data warehouse to work - Reverse ETL & Operational Analytics
summary
Claim: move modeled customer tables from the data warehouse into SaaS tools to power real workflows. Implementation uses BigQuery + dbt as source, Fivetran/Snowplow for ingestion, and Hightouch to Reverse ETL into Facebook/Google Ads, CRMs and NetSuite. Built feature: Hightouch Audiences visual builder, SQL models sync hashed PII on schedules or dbt triggers with Slack alerts. Result: replaces manual CSVs, keeps audiences fresh for hundreds of thousands–millions of users, and dramatically reduces troubleshooting surface area.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 0:40Agenda
- 1:14What is Reverse ETL
- 2:37What is ETL
- 3:20What is a CDP
- 4:33Why use a CDP
- 9:14Challenges
- 12:17Customer Data Platform
- 14:09Data Warehouse
- 15:03Hightouch
- 17:31Demo
- 17:45High Touch
related talks
23mDelivering Retail Analytics & Data Projects With Data Created For Purpose
25mPerfecting Our Modern Data Stack Recipe: What We Learned On The Journey At Huel
01h 28mA Guide to the Modern Data Stack
47mData Warehousing Migrations: Lessons from Home Depot
18mBehavioral Data Creation for AI - Delivering Value and Insights
23mDelivering Modern Data Stacks With dbt to Operationalise Analytics
39mBuilding a Modern Data Warehouse Without Breaking the Bank
43mData warehousing reinvented for today's needs