2 Your organization has taken the first big step towards becoming data-driven. Data is now flowing into your Snowflake Data Cloud and ready for consumption. You’ve gotten rid of your data silos and you now have a centralized platform to power your analytics, activation, and broader use cases. To get started, you first need to leverage the power of Snowflake to transform your data from its raw state into a usable format. Thanks to dbt , there is an easy and powerful method to handle your data transformations. At its core, dbt is a data transformation framework designed to run on top of your central data platform (i.e., Snowflake in this case). With dbt, you can collaborate on SQL models and execute them against Snowflake. The main advantage of dbt is that it makes it simpler for your data teams to adopt software engineering best practices such as version control, testing, and documentation to increase productivity. If you leverage dbt, you can test and document your transformation jobs prior to production. Version control is also simple to implement because dbt integrates with Git. With dbt running on Snowflake, it’s even easier to power your dashboards and reports for analytics. The question is, how do you take action on all your unique customer data that lives in Snowflake? This is the exact problem Hightouch solves with Reverse ETL : syncing data from Snowflake to the tools your business teams rely on. Hightouch is a Data Activation Platform that queries directly against Snowflake, enabling you to leverage SQL or your existing dbt models to sync data to over 90+ destinations . With Hightouch all you have to do is define the columns in your data model and map them to the appropriate fields in your destination. WHY SNOWFLAKE + DBT + HIGHTOUCH CASE STUDY Lucid Optimizes Ad Spend with Snowflake, dbt, and Hightouch 2 Lucid is a visual collaboration suite that combines virtual whiteboard, intelligent diagramming, and cloud visualization to help hybrid teams of all sizes innovate faster. Lucid leverages Snowflake, dbt, and Hightouch in parallel to create a 360-degree view of the customer to optimize ad performance and create customized marketing campaigns for different audiences. • Lucid now has a data-driven marketing tech stack built on Snowflake Data Cloud, dbt, and Hightouch. • With dbt and Snowflake, transformations that used to take hours can be done in minutes. • Using Hightouch and Snowflake, Lucid achieved a 52% increase in ROAS in Google and a 37% increase in new users. • Since adopting this Hightouch and Snowflake, Lucid’s engineering team has been able to save an average of 12.5 hours of engineering time per integration. CHAMPION GUIDES