Onix
99 Case Studies
A Onix Case Study
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.
American global fitness technology company