The Client
The US-based client, headquartered in Texas, is an award-winning creator of mobile games, with more than 50 million downloads globally for one of its games.
The Challenge
The client’s mission is to provide intuitive and personalized gaming experiences for its global audience. It depended on real-time business intelligence to improve the player experience, recommend personalized offers, and gain behavioral insights to hone its gaming strategy.
The client deployed Snowflake as a data storage and analytics platform. However, with a growing user base, the volume of data increased exponentially to 300GB per day, cumulatively becoming a 300TB data dump to manage, parse, and analyze. Snowflake could not support this volume expansion, and the client’s data analytics teams experienced latency and scalability issues, leading to missed business opportunities.
The Solution
The client turned to Persistent, a global leader in enterprise data engineering and management, to migrate to a cloud-based data platform that can handle the surge in data volumes and support real-time analysis of streaming data to glean actionable insights.
Persistent recommended migrating 300TB of historical data from Snowflake to BigQuery, Google Cloud Platform’s (GCP) fully managed enterprise data warehouse that helps manage and analyze data with built-in features such as machine learning (ML), geospatial analysis, and business intelligence. Our experts set up secured migration pipelines, upholding data integrity and quality in transit from the source to the target platform. We also scheduled daily jobs leveraging Airflow to handle incremental data loads.
Integration with BigQuery also allows the client to tap into the GCP advanced analytics ecosystem, with access to Artificial Intelligence (AI) and ML capabilities for more granular, real-time insights from an ever-expanding data pool.
The Outcome
With successful migration from Snowflake to BigQuery, the client was able to:
- Accelerate time to insights by 25% with improved query performance
- Scale data platform according to increasing data volume and maintain data integrity and quality
- Save 10% in operational costs with BigQuery’s on-demand pricing model
- Integrate with GCP’s advanced AI/ML capabilities
