HASHMAP SOLUTION PROFILE

NORTH AMERICAN SPECIALTY RETAILER

Advisory and Architecture Services for PII Security in the Cloud

CHALLENGE
  • Ensuring that Personally Identifiable Information (PII) in the retail datasets stored, transformed, and processed in the cloud was completely secure in Snowflake with AWS including full Securitization, Table Segregation, Access Role Limitations, Masking, and Usage.

OUTCOME
  • Designed and deployed a native 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

    • Ensures that the retail datasets with PII are completely secure

APPROACH
  • Quick assessment, validation, and design, along with mentoring and coaching that ultimately followed a six step technical 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

SOLUTION
  • Snowflake

  • AWS

  • Hashmap Consulting Services: Cloud and Data Security, Data Platform Architecture and Design, Data Warehouse Engineering, Data Pipelining

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.