Case Study: FanDuel saves 6+ months on a regulated Redshift-to-Databricks migration with Datafold
Key results
The challenge
FanDuel needed to migrate from Redshift to Databricks while managing more than 1,100 dbt models across multiple source systems and 25 regulatory reports in a heavily regulated environment. Manual comparison of legacy and new outputs was slow and costly, and regulatory reporting left little room for error.
The solution
FanDuel deployed a dual-pipeline architecture using Datafold's data-diff validation across raw source data, complex business logic, and regulatory reporting outputs, replacing manual comparison with automated cross-database validation.
The results, in context
FanDuel performed more than 15,000 individual data-diff validations across 1,100+ dbt models and 25 regulatory reports, saving over 6 months of engineering time. Validation dropped from hours to minutes per comparison, with 3-4 days saved on each complex regulatory report.