Showing masked column when they should not

carlos_tasayco — Thu, 12 Jun 2025 14:34:30 GMT

In my organization we mask some column because they are PII, I have a dlt pipeline, I am masking these columns like this:
CASE WHEN is_account_group_member("BDAIM-{environment.upper()}-PII_Unmask") THEN Personshopper.firstName ELSE mask(Personshopper.firstName) END AS firstName,
CASE WHEN is_account_group_ember("BDAIM-{environment.upper()}-PII_Unmask") THEN Personshopper.middleName ELSE mask(Personshopper.middleName) END AS middleName,

I see the data masked, but my user should not see those masked, because my user belong to a group where we can see unmasked data, I checked is working in views or tables but not in materialized views, I have tried to change the ownership of the pipeline to my user, delete and re create the materialized view but nothing is working.

Anyone has been in this issue? masking materialized views from dlt pipelines, but unmasked them when a user comes from a particular group where they should be able to see this data unmasked?

Any help would be appreciated.

Thanks

Re: Showing masked column when they should not

nikhilj0421 — Thu, 12 Jun 2025 16:39:13 GMT

Hi @carlos_tasayco, this is supported for materialized views. Please check the document to confirm if you're using the right syntax: https://docs.databricks.com/aws/en/dlt-ref/dlt-sql-ref-create-materialized-view#examples

Please let me know if you still face the issue.

topic Showing masked column when they should not in Data Engineering

Showing masked column when they should not

Re: Showing masked column when they should not