Activate Your Data in Snowflake

Ebook | 11 Pages

ACTIVATE YOUR DATA IN SNOWFLAKE WITH DBT AND HIGHTOUCH IN 6 STEPS

2 Why Snowflake + dbt + Hightouch 2 Case Study: Lucid Optimizes Ad Spend with Snowflake, dbt, and Hightouch 3 Setting Up Hightouch: A Six-Step Guide 9 Get Started Today 10 About Snowflake

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

Activate Your Data in Snowflake - Page 3
Current Time 0:00
Duration 31:29
Loaded: 0.00%
Stream Type LIVE
Remaining Time 31:29
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected

      3 SETTING UP HIGHTOUCH: A SIX-STEP GUIDE STEP 1: CONNECT HIGHTOUCH TO SNOWFLAKE Connecting to Hightouch is as simple as filling in some basic account information. Since Hightouch simply queries directly against Snowflake, no data is ever stored, giving you full control over how your data is used. CHAMPION GUIDES

      4 STEP 2: CONNECT HIGHTOUCH TO YOUR DESTINATION Connecting Hightouch to your destination is simple as well. All you have to do is fill in your API key and you can start syncing data immediately. Hightouch has over 90+ integrations and one of the more popular use cases is syncing data to Braze for lifecycle marketing campaigns. (See our guide, How to Sync Snowflake Data to Braze in Six Steps, for more information.) CHAMPION GUIDES

      5 STEP 3: CREATE A DATA MODEL OR LEVERAGE YOUR EXISTING DBT MODELS With Hightouch you can create a new data model using standard SQL or leverage any of your existing dbt model s. All you have to do is connect your dbt account to Hightouch by retrieving your API key. Hightouch even has a Visual Audience Builder for your non-technical users so they can visually filter audiences based on specific properties or events. Learn more about optimizing your dbt and Snowflake implementation in our Best Practices for Optimizing Your dbt and Snowflake Deployment guide. CHAMPION GUIDES

      Activate Your Data in Snowflake - Page 6
      Current Time 0:00
      Duration 9:01
      Loaded: 0.00%
      Stream Type LIVE
      Remaining Time 9:01
       
      1x
        • Chapters
        • descriptions off, selected
        • captions off, selected

          6 STEP 4: CHOOSE YOUR PRIMARY KEY With Hightouch you can map on any unique key. Other solutions frequently only let you map on a unique ID field. CHAMPION GUIDES

          Activate Your Data in Snowflake - Page 7

          7 STEP 5: CREATE A SYNC After you have created your sync, all you have to do is choose which columns you like to include and map those to the appropriate Braze fields, so you can start leveraging the data for your marketing campaigns. CHAMPION GUIDES

          8 STEP 6: SCHEDULE YOUR SYNC Hightouch lets you choose how often you run your syncs. You can trigger syncs manually or schedule them to run on a set interval. If you use dbt, you can even trigger syncs to run after specific dbt jobs complete. CHAMPION GUIDES

          9 Getting started with Hightouch is straightforward, and the first integration is completely free. All you have to do is connect to Snowflake and your end destination. Once you’ve done that you can access all of your existing dbt models and start syncing your data to your end destination. Since Hightouch queries directly against Snowflake, you will have full control over how your data is used and how it is stored. Best of all, you can configure your syncs to run whenever it is convenient for you, whether that be on a set interval, a custom recurrence, after your dbt job completes, or even manually. G E T S TA RTE D TODAY CHAMPION GUIDES

          ©2022 Snowflake Inc. All rights reserved. Snowflake, the Snowflake logo, and all other Snowflake product, feature and service names mentioned herein are registered trademarks or trademarks of Snowflake Inc. in the United States and other countries. All other brand names or logos mentioned or used herein are for identification purposes only and may be the trademarks of their respective holder(s). Snowflake may not be associated with, or be sponsored or endorsed by, any such holder(s). ABOUT SNOWFLAKE Snowflake delivers the Data Cloud—a global network where thousands of organizations mobilize data with near-unlimited scale, concurrency, and performance. Inside the Data Cloud, organizations unite their siloed data, easily discover and securely share governed data, and execute diverse analytic workloads. Wherever data or users live, Snowflake delivers a single and seamless experience across multiple public clouds. Snowflake’s platform is the engine that powers and provides access to the Data Cloud, creating a solution for data warehousing, data lakes, data engineering, data science, data application development, and data sharing. Join Snowflake customers, partners, and data providers already taking their businesses to new frontiers in the Data Cloud. S nowflake.com . ABOUT HIGHTOUCH Hightouch is the world’s leading Data Activation platform, which syncs data from data warehouses to various SaaS tools (no API integrations or scripts required). Hightouch was founded on the notion that every business team—sales, marketing, support, success—needs relevant, accurate, and real-time customer data in the software they use to talk to customers, including CRM, ads, email, and support platforms. For more information, visit hightouch.io . ABOUT dbt LABS dbt Labs was founded to solve the workflow problem in analytics, and we created dbt to help. With dbt, anyone who knows SQL can build, test, and deploy data transformation pipelines without filing a ticket. Today there are 9,000 companies using dbt every week, 27,000 practitioners in the dbt Community Slack, and 1,800 companies paying for dbt Cloud. www.getdbt.com