HASHMAP SOLUTION PROFILE
GLOBAL OIL FIELD SERVICES
Migration and Performance Testing of Exadata to Snowflake in Azure
CHALLENGE
-
Achieve high performance for Oracle Exadata (source) table extraction and data transformation into a CSV file and ingestion into Snowflake Cloud Data Warehouse in Azure
-
Enable a migration from a traditional Oracle Exadata data warehouse environment to Snowflake Cloud Data Warehouse
OUTCOME
-
Significant performance gains for data migration from Exadata to Snowflake in Azure
-
A simple approach with a single step process to read from Exadata and migrate data to Snowflake in Azure using zero local disk space
-
Complete solution that accommodates all Exadata tables
APPROACH
-
Launch meeting to review issues and challenge for the project
-
Designed, implemented, and tested an extraction, transformation, and processing routine that demonstrated a 10x performance gain over the prior method
-
Benchmark testing extraction, compression, various tables, single thread, multiple threads, etc.
-
Complete documentation provided of the above
SOLUTION
-
Snowflake
-
Microsoft Azure
-
Hashmap Consulting Services: Cloud Data Migration, Data Engineering, Data Pipelining