I have a table with a Snowflake data masking policy which is on email and phone number, if I replicate the table will the data masking policy be replicated as well and work the same exact way?

1.74K viewsSecurity in SnowflakeData Masking
1

I have a table with a Snowflake data masking policy which is on email and phone number, if I replicate the table will the data masking policy be replicated as well and work the same exact way?

Frank Bell Answered question March 19, 2022
0

As long as you are not replicating to equivalent Snowflake edition than this works no problem. If the primary database is a lower edition than what you are replicating too or if its a higher edition than you are replicating too then REPLICATION will not be allowed, [you will get an error like this below]. Also, it will not work if the Data Masking Policy references a policy within another database.

Frank Bell Answered question March 19, 2022