Fivetran > Case Studies > Snowflake's Comprehensive Data Stack Development with Fivetran

Snowflake's Comprehensive Data Stack Development with Fivetran

Fivetran Logo
Technology Category
  • Analytics & Modeling - Machine Learning
  • Sensors - Airflow Sensors
Applicable Industries
  • Equipment & Machinery
Applicable Functions
  • Sales & Marketing
Use Cases
  • Time Sensitive Networking
Services
  • Cloud Planning, Design & Implementation Services
  • Data Science Services
About The Customer
Founded in 2012, Snowflake has become ubiquitous with the growing modern data stack ecosystem, delivering access to the data cloud for over 6,000 customers worldwide. Snowflake’s own growth has been driven by rapid iteration and best-in-class data practices, including the development of a powerful internal data stack that gives every employee at the organization access to data. At the core of this meteoric rise is Snowflake’s marketing intelligence function, a team with a bold vision: to predict real-time ROI to dynamically optimize all Snowflake marketing programs, disrupting legacy B2B marketing analytics practices, and create huge efficiencies.
The Challenge
Snowflake, a leading data cloud company, was looking to centralize its data within the organization's Snowflake instance, ‘Snowhouse,’ to power segmentation models, recommendation engines, and ultimately build a 360-degree view of customers. The marketing intelligence team at Snowflake had a bold vision to predict real-time ROI to dynamically optimize all Snowflake marketing programs, disrupting legacy B2B marketing analytics practices, and create huge efficiencies. However, the company faced challenges in breaking down data silos and enabling efficient analytics. Snowflake used to keep its data modeling and transformation logic within a separate BI tool, which was time-consuming and prone to error. Every time the business needed to run models out of the tool, or conduct ad-hoc analytics, analysts needed to recreate their models from scratch.
The Solution
Snowflake partnered with Fivetran to build a comprehensive data stack. Fivetran, a critical part of the modern data stack for Snowflake, provided over 900 connectors moving over 400 million monthly active rows, both through marketing analytics connectors such as Google, Bing and Facebook Ads, and core SaaS tools like Marketo, Salesforce and Jira. The implementation of dbt Core™ enabled a much more flexible experience for end users within the business. The team saw better overall performance as most of the compute-intensive calculations were conducted earlier in the process. Snowflake also used Airflow to manage dbt™ jobs and define however often they want to update their models and tables, giving analysts the ability to balance data refresh times with performance and cost considerations. The company established a data consumption layer where the marketing analytics team enables collaboration and invites its business partners to start their interactions with the data.
Operational Impact
  • The implementation of Fivetran’s suite of connectors and dbt Core™ transformed Snowflake's data management and analytics. The company was able to break down data silos and centralize its data, enabling a 360-degree view of customers. This allowed the marketing team to drive massive efficiencies in marketing spend and targeting. The use of dbt Core™ and Airflow also improved the flexibility and performance of data modeling and transformation, reducing time and error. The establishment of a data consumption layer facilitated collaboration and data interaction among business partners. The company also addressed the need for clear data lineage, cataloging, and governance with Alation, a tool which takes the metadata from Snowflake to automatically outline data lineage and the content of different tables.
Quantitative Benefit
  • Deployed over 900 Fivetran connectors moving over 400M monthly active rows.
  • Built a 360-degree view of customer behavior, enabling the marketing team to drive massive efficiencies in marketing spend and targeting.
  • Established a comprehensive data consumption layer, which enables hundreds of internal customers and citizen analysts to access critical data.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.