Creates a new masking policy in the current/specified schema or replaces an existing masking policy.
After creating a masking policy, apply the masking policy to a column in a table using an ALTER TABLE … ALTER COLUMN command or a view using an ALTER VIEW command.
https://docs.snowflake.com/en/sql-reference/sql/create-masking-policy.html#normal-masking-policy
In Snowflake, masking policies are schema-level objects, which means a database and schema must exist in Snowflake before a masking policy can be applied to a column. Currently, Snowflake supports using Dynamic Data Masking on tables and views.
Table and Mat view can be applied with masking policies,
https://docs.snowflake.com/en/user-guide/security-column-intro#label-security-column-intro-mv:~:text=Snowflake%20allows%20setting,materialized%20view%20columns.
A and C,
for materialized views they are not allowed to be created on columns that has a masking policy. But you can apply a masking policy on materialized views.
https://docs.snowflake.com/en/user-guide/security-column-intro.html#label-security-column-limitations Masking policy can be applied on Mat view columns as well
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
halol
Highly Voted 1 year, 11 months agohalol
1 year, 11 months ago_yyukta
Most Recent 8 months, 2 weeks agoMarge23
1 year, 1 month agoMultiCloudIronMan
1 year, 4 months agoDataEngineer7331
1 year, 6 months agolearner2023
1 year, 7 months agoKarBiswa
1 year, 8 months agoEmiB
1 year, 8 months agoppsingh001
1 year, 9 months agoBigDataBB
1 year, 10 months agoyogen
1 year, 10 months agoKate0204
1 year, 11 months ago