Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

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?

3.09K 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

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A