Top International Airport Accelerates Migration to Snowflake, Modernizes Data Cloud Capabilities, & Saves More Than $1M/Year
Data Transformed by the Numbers
Platforms & Systems
Overview
One of the world’s largest airports wanted to optimize its operations.
By migrating from an outdated environment into Snowflake, the new Modern Cloud Data Architecture provided the advanced analytics and outcome predictions to improve performance, increase customer satisfaction, and increase revenue generation in multiple aspects of the airport’s operation.
Challenges
The airport was operating in an outdated Oracle environment that hindered its ability to perform timely advanced analytics to operate more efficiently and cost effectively. At 21TB uncompressed for its parking data alone, the airport did not have enough resources to run advanced data reporting and modeling to optimize its parking capacity. Similarly, the airport did not have the data architecture nor resources to improve its performance in flight transfers, baggage claims, and TSA wait times.
Solutions
Armeta successfully accelerated the airport’s data migration to Snowflake, modernized the airport’s data cloud architecture, and seamlessly migrated reports and processes to Snowflake without interruption to end-users. Armeta used its proprietary Cloud Migration Accelerator™ and ETL Automation Accelerator to move massive amounts of data as well as re-factor existing ETL jobs from source to Snowflake — all in a fraction of the time compared to our benchmark competitors.
Results
- $1M per year in maintenance and licensing savings.
- Increase in parking and airline revenue.
- Increase in customer satisfaction.
- Accelerated time to value operating in Snowflake.
The customer’s decision to modernize its data cloud architecture and migrate to Snowflake yielded significant business impact across many aspects of its operations.
- Parking: The airport optimized parking capacity and increased revenue by advanced behavior predictions on long-term vs. short-term parking.
- Restrooms: The airport increased customer satisfaction by the ability to analyze IoT data from bathroom sensors.
- Flight Transfers: The airport improved arrival/departure performance through the ability to predict flight transfer characteristics between terminals.
- Baggage Claims: The airport reduced baggage wait times through the ability to analyze and predict hourly, weekly, and seasonal traffic.
- TSA Wait Times: The airport improved wait times by analyzing foot traffic IoT data and predicting terminal and gate wait times.
Featuring Armeta
The star of the show, Armeta Cloud Migration Accelerator™, moved 70TB in just 8 weeks from Oracle to Snowflake while keeping all data at the source and target in synch for continuous availability and operations.