HASHMAP SOLUTION PROFILE

GLOBAL ENGINEERING & CONSTRUCTION

Security Advisory Services and Best Practices for Snowflake in Azure

CHALLENGE
  • Acceleration and confirmation of a plan and approach for setting up security in Snowflake that will establish Snowflake in Microsoft Azure as the enterprise Cloud Data Warehouse 

  • Enable a plan and model that will facilitate both initial use cases and the expected future growth of the platform across regions and countries

APPROACH
  • Conducted review & design sessions and hands-on customized labs for multi-country participants focused on design and architectural approaches, perspectives, pros/cons including: 

    • Access control considerations including privileges and configuration

    • Account and User authentication and SSO (AD)

    • User roles and groups

    • User management

    • Schemas

    • Object Security

OUTCOME
  • Comprehensive review and recommendations on setting and leveraging Security controls in Snowflake and integrating with existing systems and processes that provided:

    • Comprehensive coverage of security in Snowflake that helped in planning for near term and future growth

    • An ability to envision a path to growth with security concerns addressed and take full ownership of the solution

SOLUTION
  • Snowflake Cloud Data Warehouse in Azure

  • ADLS and Blob Storage

  • Microsoft AD

  • Hashmap Consulting Services: Cloud Data Architecture, Data Warehouse Engineering, Data Integration & Pipelining, Security and Controls in Snowflake

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.