New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
Compliance needs to see real customer data sometimes. Every analyst who queries the same table sees it too.
What you'll have at the end
A masking policy that shows analysts a redacted value and compliance the real one, from the same column
You need
A Snowflake table holding a column of real PII, such as a customer's SSN, that more than one existing role, analysts and a compliance or privacy role alike, can currently query unmasked, a Snowflake edition of Enterprise or higher, and access to a role, such as ACCOUNTADMIN, that can create roles and grant privileges.
Not covered
Row-level filtering so two teams see different rows of the same table, and the aggregation and projection policies that stop small-group re-identification or a bare select of every column, since those protect a different surface than one column's value.
Leans on
Checked 26 Aug 2026
Part of the Snowflake Data Cloud cookbook