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

©2020 by Hashmap, Inc.

OKC

1141 W Sheridan Ave

Suite P2

Oklahoma City, OK 73106

SNOWFLAKE SOLUTION PROFILE

CONVENIENCE STORE RETAILER

Migration from a SQL Data Lake on Hadoop and Hive to Snowflake on AWS with Tableau and Attunity

CHALLENGE
  • Replication of the current Apache Hive ingest into Snowflake 

  • Demonstrate the usability of Snowflake data from a SQL perspective 

  • Demonstrate the usability of Snowflake from a Tableau consumption perspective 

  • Showcase a Databricks Spark data pipeline flow into Snowflake

  • Ultimately, develop a clear feel for how Snowflake can replace the current HDP Hive infrastructure and associated costs

APPROACH
  • Hands-on demonstrations and mini-POCs across a variety of dimensions showcasing Snowflake features and capabilities

  • Data loading of table extracts

  • Cloned tables, staged stables, connected via JDBC and via Tableau

  • Connected and demonstrated Databricks functionality

  • Knowledge transfer

  • Built several views

  • Demonstrated Snowpipe

  • Reviewed best practices and guidelines

  • Provided documentation

OUTCOME
  • Completed the Snowflake functional POC testing and review and closed all outstanding questions and concerns

  • Assisted in enabling the client to move forward with business and technical approval for Snowflake

  • For the full migration, provided data engineering and architecture services including data acquisition (bulk load and incremental load), data transformation, data persistence, and data consumption.

SOLUTION
  • Snowflake Cloud Data Warehouse

  • Databricks Spark

  • AWS

  • Hashmap Consulting Services: Snowflake and Databricks POC Enablement Services, Hashmap Migration Services (Data Engineering and Data Architecture)

Connect with Hashmap

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