
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