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