Customer Stories

A Large Healthcare Organization Migrates from Teradata to Snowflake

Share
0 %
Cost reduction on Snowflake vs Teradata
0 x
Faster testing on Snowflake
0 %
Increase in query efficiency

Full decommissioning of the legacy Teradata platform.

All applications and dashboards running on Snowflake.

Alerts and monitoring put in place to proactively monitor performance.

Challenge

A large healthcare payer needed to migrate 12 databases and more than 2 Petabytes of data from Teradata to Snowflake.

The healthcare organization struggled with testing, logging, and slow iterations, requiring 96 hours across 3 people a week to manage manual migration processes. 

The healthcare payer sought to quickly migrate all databases to Snowflake and fully decommission Teradata. Their key indicators of success were cost reduction, faster query performance, and human resource reduction. 

Solution

Hakkoda’s expert Healthcare & Life Sciences team built a POC focused on migrating the largest table of data, delivering a high value/high usage dashboard and optimizing the most expensive queries. The POC was a success, and the large healthcare organization was able to continue their migration confident that Snowflake was the best solution.

3 workstreams were created to migrate all databases in parallel. All pipelines were connected & BI dashboards were rebuilt to work with Snowflake. Each workstream ensured the DDL conversion and migration was done correctly. All data was validated to ensure quality.

More than 700 queries were migrated and Teradata was decommissioned. Hakkoda optimized and improved efficiency across all queries and workflows, leveraging our automated accelerator, AQPT, to decrease human resource needs by 16X. Overall, the organization saw 60% cost reduction and 85% faster testing on Snowflake.

The Model

1 Hakkōda Accelerator Used:

AQPT

5 Full Time Resources:

3 Data Engineers

1 Data Scientist

1 Data Analyst

Project Duration:

8 Months

“Hakkoda continues to work closely in a flexible model with the large healthcare organization. The initial team focus was around architecture and engineering. We have now moved into data science and app development as the healthcare organization has become more familiar and comfortable building on Snowflake.”
– Dana George, Lead Data Scientist

Case studies

Hakkoda - Family Real Estate - Thumbnail
Case Studies
Learn how a single family real estate asset manager cut systems sprawl by 25% and consolidated business intelligence in Snowflake...
Case Studies
Case Studies
Learn how a large regional bank broke down data silos and accelerated its data governance program with the development of...
Case Studies
Hakkoda - VGS Customer Story - Thumbnail
Case Studies
Learn how VGS Built a Streamlit App to Perform Tokenization in Snowflake by leveraging Hakkoda's expert data monetization teams.
Case Studies