HASHMAP SOLUTION PROFILE

INDEPENDENT UPSTREAM OIL & GAS

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

CHALLENGE
  • Data is collected from active drilling operations via an EDR service provider.

  • This drilling data is required by a broader group within the company for combining with other datasets to create dashboard reports, perform domain calculations, and develop analytical models which can be utilized by drilling engineers to validate and improve drilling practices.

OUTCOME
  • Allowed for schema changes and/or variation by well and services

  • Removed 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

  • Provides an ability to serve larger datasets to end users in Spotfire

  • Provides a solution for a broader 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

  • Azure Data Factory

  • Azure DevOps

  • dbt

  • Spotfire and PowerBI

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

HashmapLogoBlack_edited.png
  • Hashmap on LinkedIn
  • Tweet Hashmap
  • Hashmap on Facebook
  • Hashmap Stories
  • Data Rebels on Tap on Spotify
  • Hashmap on YouTube
  • Hashmap on Instagram

© 2020 by Hashmap, Inc.