Core Digital Media and NAVEX

Many of our customers — from Marriott to AT&T — start their journey with the Snowflake AI Data Cloud by migrating their data warehousing workloads to the platform. 

For organizations who are considering moving from a legacy data warehouse to Snowflake, are looking to learn more about how the AI Data Cloud can support legacy Hadoop use cases, or are struggling with a cloud data warehouse that just isn’t scaling anymore, it often helps to see how others have done it. 

That’s why we’ve collected these migration success stories to help you get started on your migration to Snowflake. This blog is the first in a three-part series on migrations. Today we’re focusing on customers who migrated from a legacy data warehouse to Snowflake and some of the benefits they saw.

Digital advertiser switches from Teradata and boosts performance by 30%

Core Digital Media originally relied on its outdated Teradata appliance for its increased MicroStrategy and Tableau reporting, data science activity, and evolving data pipeline. However, the leading digital advertiser needed to deliver timely insights to 150 users across marketing, IT, data science, and product, and with its slow performance, it became clear that their  Teradata appliance was approaching end-of-life status.  

Core Digital Media’s BI team began evaluating infrastructure enhancements. The company quickly realized maintaining 10 years’ worth of production data while enabling real-time data ingestion led to an unscalable situation that would have necessitated a data lake. 

The company migrated from its outdated Teradata appliance to the Snowflake AI Data Cloud to resolve performance issues and meet growing data demands. Core Digital Media’s Teradata system struggled to handle the increasing load from reporting, data science and real-time data ingestion. This caused system contention, missed SLAs, delayed report deliveries and significant maintenance overhead. Snowflake’s cloud-native architecture offered the scalability and performance Core Digital Media required to eliminate these bottlenecks.

The transition to Snowflake led to a significant performance boost, with BI report generation improving by 30%. Snowflake’s separate clusters for ETL, reporting and data science eliminated resource contention. The company also used prebuilt connectors like Apache Kafka and Informatica simplified data integration to deliver better insights across the organization. Within four months, Core Digital Media had fully transitioned to Snowflake, decommissioning Teradata. Snowflake’s fully-managed services, including zero-copy cloning, allowed the company to focus on building data-driven applications rather than managing infrastructure.

Snowflake’s scalability also allowed Core Digital Media to process continuous streams of advertising data from Facebook and Google, helping the marketing and analytics teams with real-time insights. Data scientists also benefited from a scalable environment to build machine learning models without fear of system crashes. Snowflake’s flexible architecture and cost-effective per-second pricing lowered the company’s total cost of ownership by eliminating the need for a separate data lake, enabling greater innovation and resilience.