HASHMAP SOLUTION PROFILE

NORTH AMERICAN SPECIALTY RETAILER

Advisory and architecture services for Snowflake security

CHALLENGE
  • Ensuring that Personally Identifiable Information (PII) was completely secure in Snowflake including full Securitization, Table Segregation, Access Role Limitations, Masking, and Usage.

APPROACH
  • Followed a six step approach:

    • Located all columns containing PII

    • Segregated tables containing PII

    • Protected the segregated tables

    • Replaced the original tables with masked data

    • Granted regular users access

    • Used the newly compliant database

OUTCOME
  • A solution to securing PII in Snowflake that:

    • Uses built-in Snowflake security features - Roles, Default Schemas, and Secure Views

    • Is extensible across use cases

    • Requires limited extra effort to implement

SOLUTION
  • Snowflake Cloud Data Warehouse

  • AWS

  • Hashmap Consulting Services: Cloud Data Migration, Data Warehouse Engineering, Data Pipelining, Cloud Security

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.