HASHMAP SOLUTION PROFILE

GLOBAL EPC

Cloud & Data 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

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

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

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

Connect Now >