Search code examples
snowflake-cloud-data-platformdynamic-data-masking

Changing masking policy without unsetting that masking policy

Is it possible to alter an existing masking policy without unsetting this policy?

For example, I have a masking policy that is set to multiple columns. So, when I want to change the policy to include more roles, I have to first unset the policy from every column (which takes a lot of time).

Solution

  • Yes - just run an ALTER MASKING POLICY... command