Data Masking

[JanFalta]

Hi all,

I need some help on this masking problem. If you create a view with used masking function based on table.
The user reading this view has to have read access to underlying table. So theoretically, he can access unmasked data in the table.

I would like to have solution, which will allow me to mask the table the way, that if the user reads data, based on his role, masking is applied or not. Is there a way to build it in Databricks?

Thank you Jan

[AbhaySingh]

Are you on Unity catalog? 

Databricks has a solution for this through Unity Catalog Column Masking (also called Dynamic Views or Column-Level Security).

https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/filters-and-masks/