
HASHMAP SOLUTION PROFILE
FORTUNE 100 ENERGY COMPANY
Delivering Faster Insights with Snowflake API Development
CHALLENGE
-
A business unit was retiring an out-of-date legacy technology and needed API access to Snowflake data immediately without connecting directly or creating a shared database for different business units
-
Data Accessibility via API with limited connectivity options
OUTCOME
-
Built a secure and scalable API on top of Snowflake leveraging Python and existing Azure resources so the BU could access data without connecting to Snowflake
-
Successfully validated API design, architecture, and approach in a way that could be applied to other business units in the future
-
Fully tested and productionized API delivered in less than one month
APPROACH
-
Discover - Worked with key stakeholders, business users, and technical owners to align business outcomes and discover existing Azure resources that could be leveraged
-
Design - Designed and architected an API in partnership with the BU team
-
Develop - Created a data access API for Snowflake
-
Delivered - Secure, scalable, and speedy API that resolved client challenges
SOLUTION
-
Snowflake
-
Azure (Functions, API, Frontdoor, AD, OAUTH2.0, WAF)
-
Python
-
Hashmap Consulting Services:
-
API Development Services
-
Snowflake Cloud Data Strategy & Advisory
-
Snowflake Cloud Data Snowflake Design, Engineering, & Architecture
-