Requirement to remove/skip column(s) in the downstream tables/views while PII data masking

[RiyazAli]

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.

[Walter_C]

Is there a reason for this column to not to be masked, the main reason of this mask operation is to hide the columns for non compliant users, so the only option will me to mask it.