contact@hashmapinc.com (general inquiries/questions)

-or-

careers@hashmapinc.com (send your CV/Resume to start the process of becoming a Hashmapper)

(770) 857-3919

ATLANTA

1000 Holcomb Woods Pkwy

Building 100, Suite 118

Roswell, GA 30076

HOUSTON

440 Cobia Drive

Building 204

Katy, TX 77494

TORONTO

4145 North Service Road

2nd floor

Burlington, Ontario L7L6A3

INDIA

Midas Tower

Plot # 44, RGIP Phase 1

Hinjewadi, Pune

Maharashtra, India

  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Hashmap Stories
  • Listen to IoT on Tap with Hashmap
  • Hashmap on YouTube
  • Hashmap on Instagram

©2019 by Hashmap, Inc.

OKC

1141 W Sheridan Ave

Suite P2

Oklahoma City, OK 73106

SNOWFLAKE SOLUTION PROFILE

GLOBAL OIL FIELD SERVICES

1 Week POC Migration and Performance Testing of a traditional Data Warehouse 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 Azure

  • A simple approach with a single step process to read from Exadata and migrate data to Azure using zero local disk space

  • Complete solution that can accomodate all Exadata tables

APPROACH
  • Launch meeting to review issues and challenge for the 1 week POC

  • 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 Cloud Data Warehouse

  • Microsoft Azure

  • Hashmap Consulting Services: Cloud Data Migration, DW Engineering, Data Pipelining

Connect with Hashmap

  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Tech & Engr Blog
  • IoT on Tap with Hashmap
  • Hashmap on YouTube