I am exploring using "masking policies" for my current company. Currently, they leverage secure views for PII information. Ideally, I am trying to use masking policies to hide this information. I am seeing in the documentation that masking policy is a schema level object.
We have hundreds if not thousands of schemas and am wondering if its possible to use a masking policy across many of the schemas? Or even better a masking policy at the account level across multiple databases and schemas?
According to this blog, it seems possible.
Any guidance is appreciated!
For other people. Following snowflakes documentation I created a role called "masking_admin" that is able to apply the masking policy across multiple databases and schemas. Technically the policy resides in the schema but can be applied more broadly. Cheers and best of luck!