Case Study: a American global fitness technology company achieves scalable, high-performance analytics with Onix and BigQuery migration

A Onix Case Study

Preview of the American global fitness technology company Case Study

American global fitness technology company migrates 186 TB to BigQuery with Onix

An American global fitness technology company faced challenges scaling its complex analytics environment built on Amazon Redshift. As data volumes grew, the platform struggled with performance, scalability, and cost efficiency. The customer needed to migrate to a new solution without disrupting its critical business intelligence workflows and interconnected systems, including Airbyte, Airflow, dbt, and Looker. Onix was engaged to manage this high-risk migration.

Onix executed a seven-month migration to Google BigQuery, moving 186 TB of historical data and thousands of database objects. They utilized their Pelican tool for automated data validation and refactored thousands of dbt models and Airflow workflows for BigQuery compatibility. The result was a modern, high-performance platform that delivered faster query execution, seamless scalability, and improved cost efficiency with no disruption to existing reporting. The customer is now well-positioned to support advanced analytics and machine learning.


View this case study…

Onix

99 Case Studies