Snowflake Cloud Test Data Management Solution for Innovation

In Banking & Financial Services, Insurance, Healthcare, Manufacturing, Retail, and Media domains, data plays a vital role in driving the business efficiently. Ensuring that any user, process, or application does not misuse data is equally important. With the GDPR mandate and PII regulations, one must be cautious about securing customers’ sensitive data. Customer data, called the PII data like Account Numbers, SSNs, Tax IDs, etc., is highly sensitive. There are very stringent data protection policies in many countries. E.g., GDPR mandate in European countries. Organizations take utmost care to protect this data, but there are use cases where this sensitive data is required to be accessed by people who are not the owners of it, like IT teams. Data in Test/QA environments are open and easily accessed by developers and QA teams.

Organizations have multiple environments for development and QA activities. Data masking policies are applied in Prod, but what about the lower environments? How can one hide the above PII-related information in Test/QA environments? How can one hide this information in cloud platforms like Snowflake? And be consistently done across all environments.