Hi there,

As a compliance measure, I'm tasked with masking the PII data starting from bronze to silver and all the tables and views downstream. I suggested my clients to use row filters and column masks as mentioned in the doc.

However, when a user who doesn't have access to a particular tables queries it, he SHOULD NOT be able to see any of the PII column in that table (not masked, the columns should be invisible to non-compliant users). But if a user with access queries it, those columns should be visible to him.

Any idea how to achieve this?

Thanks in advance.