CODEWITHSUNDEEP
snowflake-cloud-data-platformmaskingtagging
Yanli Dong
Yanli Dong

Reputation: 37

Can snowflake masking policies be assigned to tags?

I know that masking policies can be assigned to columns, for example:

alter table if exists user_info modify column email set masking policy email_mask;

But can we assign one masking policy to a tag? So that all the columns with the tag in one table can automatically be assigned the masking policy?

Thanks.

Upvotes: 0

Views: 697

Answers (2)

Dan Secrist
Dan Secrist

Reputation: 11

As of June 2022, tag-based masking policies are now in public preview: https://docs.snowflake.com/en/release-notes/preview-features.html

https://docs.snowflake.com/en/user-guide/tag-based-masking-policies.html

Upvotes: 1

Clark Perucho
Clark Perucho

Reputation: 466

The simple answer is No. Masking policies can only be attached on columns of Tables and Views.

If you are looking to automatically assign Masking Policies to tagged columns, you can do the following:

  1. Join the COLUMNS View and TAG_REFERENCES View to generate an ALTER Statement that sets the masking policy to tagged columns that doesn't have masking policies assigned to them
  2. Put it in a Stored Procedure
  3. Schedule a Task to run the Stored Procedure regularly

Upvotes: 1

Related Questions