Case Study: an online survey development leader achieves scalable, cost-efficient data warehousing with Snowflake and Kellton

Online Survey Development Leader migrates 120+ dashboards to Snowflake with Kellton

The client, a leader in online survey development, faced significant performance bottlenecks and high operational costs from its decade-old SQL Server Data Warehouse hosted in a private data center. With its data center contract expiring, the company needed to quickly migrate its ~12TB data warehouse to a scalable cloud solution to avoid penalties and meet growing business demands. Kellton was engaged to manage this migration to Snowflake.

Kellton implemented a metadata-driven approach, using accelerators to convert SQL code and ensure data quality through continuous regression testing. This solution successfully migrated over 1,300 database objects and 120+ dashboards to Snowflake. The project resulted in faster batch processing and reporting performance, a reduction in operational costs, and the delivery of a scalable platform for future growth. Kellton ensured an accurate and timely migration for the client.