HASHMAP SOLUTION PROFILE

GLOBAL CONNECTED PRODUCTS PROVIDER

Cloud Migration of an Hadoop Data Warehouse to Snowflake

CHALLENGE
  • Eliminate the cost and effort associated with ongoing sizing, balancing, and tuning an on-premise data warehouse for analytics driven by Tableau workbooks

  • Provide quicker and consistent self service access of consumer device hardware data across a geographically dispersed user base including the US, Europe, and Asia.

APPROACH
  • Tapped into the unique advantages of Snowflake as a cloud data warehouse for low cost storage, scale up/down elasticity, low/no operational or infrastructure overhead, virtual warehousing, and pay only for the compute cycles used.

OUTCOME
  • Delivered significant performance benefits, a simple UI, scaling, and concurrency at a fair price

  • Native support for the ORC file format bypassing a major conversion effort

  • Maintained backward compatibility with the existing Tableau workbooks limiting the scope of rework

SOLUTION
  • Snowflake Cloud Data Warehouse

  • AWS

  • Tableau

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