Can I create BOTH a MASKING POLICY and ROW ACCESS POLICY on the same table or view?
Yes, you can create and apply a row access policy and a data masking policy on the SAME table or VIEW but not on the same exact column.
Can I create BOTH a MASKING POLICY and ROW ACCESS POLICY on the same table or view?
Yes, you can create and apply a row access policy and a data masking policy on the SAME table or VIEW but not on the same exact column.
We share extensive Snowflake Solutions we have synthesized over 6 years of Snowflake Experience and Snowflake Data Superheroes for your Learning Efficiency. Sign up to receive a copy of Frank’s Snowflake Best Practices Blueprint and join 3,000+ others in receiving bi-weekly emails on data, automation and Snowflake optimization from 4x Snowflake Data Superhero.
By Frank Bell and ITS – Snowflake Solutions – Over 3000 subscribers