If you need a quick way to create masking policies in Snowflake, this template allows you to save a stored procedure that you can call any time create new or append roles to an existing masking policy. Enjoy!
Step 1 - Create masking policy stored procedure
Run the following stored procedure in your Snowflake account, as ACCOUNTADMIN.
Step 2 - Mask data!
Want to make masking data in Snowflake even easier?
Do it in ALTR!
ALTR lets you mask data in Snowflake without writing any code, so creating and maintaining masking policies is easy and doesn’t take up your time. ALTR does a lot more, too, including automatically classifying data, controlling access to data, and reporting on data usage, all for free.