E-commerceSourced

Case Study: Faire migrates 5,000+ tables from Redshift to Snowflake 6 months faster with Datafold

Faire Case StudySourced & dated by Case Study Desk

Key facts · TL;DR

Company

Faire

Industry

E-commerce

Challenge

Migrating 5,000+ tables while preserving hundreds of dashboards

Headline result

Faire validated more than 5,000 tables during its Redshift-to-Snowflake migration and completed the move 6 months faster using Datafold's Data Diff.

Key results

6 mo

Reduction in migration timeline

5,000+

Tables migrated and validated

The challenge

Faire, an online wholesale marketplace, needed to migrate from Redshift to Snowflake while maintaining Stitch and Kinesis data pipelines, preserving hundreds of Mode dashboards used by hundreds of employees, and keeping in-house ML tooling orchestrated with Airflow. The move required validating more than 5,000 tables with minimal disruption.

The solution

Faire integrated Datafold's Data Diff into its Airflow workflows to systematically compare Redshift and Snowflake across rows, columns, and schemas throughout the migration.

The results, in context

Datafold's automated cross-database validation let Faire migrate more than 5,000 tables and reduced the overall migration timeline by 6 months.

Products used

Datafold Data Diff