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?
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.