Chalo and Quantiphi: Scaling Urban Mobility with Cloud-Native Data Infrastructure
Chalo partnered with Quantiphi and Snowflake to modernize its data infrastructure, enhancing scalability and efficiency. Using the Gen AI accelerator Codeaira, Quantiphi facilitated a seamless migration from AWS Redshift to Snowflake delivering the project two weeks ahead of schedule and saving opportunity costs.
About the Client
Chalo is a leading mobility solutions provider committed to transforming public transportation systems through digitisation, making daily commutes more efficient, accessible, and reliable for millions.
Problem Statement
Their platform integrates data, operations, and decision-making processes to improve the experience for operators and commuters alike. As they expanded to newer geographies, with massive volumes of real-time data flowing in from diverse sources such as buses, GPS devices, and payment systems, their operations became highly data-hungry. The need to exponentially scale their infrastructure was imperative.
Challenges
“Our biggest challenge was migrating 3000+ queries from AWS Redshift to Snowflake while ensuring minimal disruption.”
Atmesh Mishra, AVP, Platforms Chalo
- Lack of a Unified Data Strategy: Disparate tools slowed decision-making and increased operational costs.
- Resource Contention: Infrastructure limitations hindered scalability and operational efficiency.
- Scalability Issues: Performance bottlenecks emerged due to the inability to handle growing data volumes.
- High Operational Costs: Long query runtimes led to unnecessary expenses and inefficiencies.
The Solution
Quantiphi set up a Snowflake data platform on AWS cloud for unified data management and carried out seamless data ingestion.
The key elements of the solution included:
- Unified Data Platform: Setting up Snowflake for consolidated data storage and processing, enabling workload isolation and supporting both structured and semi-structured data.
- Accelerated Query Migration: Leveraging Quantiphi’s Gen AI code conversion accelerators to expedite the query migration process, ensuring seamless integration.
- Enhanced Data Consumption: Enabling data analysis and reporting through Metabase and Periscope, improving accessibility for business users.
“By combining our expertise with Snowflake’s powerful data platform, we collaborated with Chalo to build a scalable and efficient data ecosystem. This showcases how strategic partnerships can drive innovation, optimize operations, and create smarter businesses for the future.”
Bhaskar Kalita, Executive Sponsor, Snowflake Alliance and Global Head of Financial Services and Insurance at Quantiphi
Impacts
queries converted
faster conversion with Codeaira
- Unified data platform for faster decision-making
- Improved query performance with streamlined architecture
- 50% increase in query conversion using Codeaira
- 3000+ queries were converted and consumed via Metabase
- Built future-proof and scalable infrastructure capable of handling diverse and growing data sources
Technology Used
Snowflake
codeaira
periscope
Metabase