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

INDEPENDENT UPSTREAM OIL & GAS

Accelerating a Drilling Data Store and Data Pipeline with Snowflake in Azure

CHALLENGE
  • Today, data is collected from active drilling operations via an EDR service provider. This data is required by a broader group within the company for combining with other datasets and creating dashboard reports, performing domain calculations and developing analytical models which can be utilized by drilling engineers to validate and improve drilling practices.

OUTCOME
  • Allows for schema changes and/or variation by well and services
    Removes reliance on EDR specific tooling for ingest

  • Solution scales efficiently with increasing load and allows for persistent storage of historical data
    Immediately addressed HA and DR scenarios

  • Provided an ability to serve larger data sets to end users in Spotfire

  • Provided a solution for a range of time series based use cases

APPROACH
  • Move to a cloud-centric, consumption based model that will allow for computation and calculations of drilling performance indicators such as MSE, stand detection, and rig states

SOLUTION
  • Snowflake Cloud Data Warehouse in Azure

  • Azure Data Factory

  • Azure DevOps

  • dbt

  • Spotfire and PowerBI

  • Hashmap Consulting Services: Cloud Architecture, Data Engineering, Data Pipelining, O&G Drilling Domain

Connect with Hashmap

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