Case Study: Snowflake achieves faster, fully automated migration testing with iCEDQ

Snowflake - Customer Case Study

The customer, a user of iCEDQ, faced a challenging data migration from Netezza to Snowflake, driven by a previous manual migration that took 18 months and resulted in numerous post-launch defects. To avoid a repeat of this costly and resource-intensive process, they sought an automated data testing strategy for their new project, which involved migrating 17 terabytes of data and 5,000 objects.

The vendor iCEDQ provided its DataOps Platform and RuleGen utility to automate the testing. The solution automatically generated 15,000 test rules, enabled direct data comparison without staging, and provided detailed exception reports. This resulted in a migration completed in just 5 months with 5 staff, a 95% automation level, 100% test coverage, and zero data defects found in production, drastically reducing both timeline and resource requirements compared to the previous project.

Snowflake