Showing masked column when they should not

[carlos_tasayco]

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

[nikhilj0421]

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.