A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a…

According to the SnowPro Advanced: Architect documents and learning resources, column masking

policies are applied at query time based on the privileges of the user who runs the query. Therefore,

if a user has the privilege to see unmasked data in a column, they will see the original data when

they query that column. If they load this column data into another column that does not have a

masking policy, the unmasked data will be loaded in the new column, and any user who can query

the new column will see the unmasked data as well. The masking policy does not affect the

underlying data in the column, only the query results.

Reference:

Snowflake Documentation: Column Masking

Snowflake Learning: Column Masking