Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
2 years ago

Conditional dynamic data masking

Hi, thinking a customer table to query, is it possible to show/mask the customer name respect to the value of the customer type? Only for specific customer types the customer date have to be visible...
governance
one lake
security
workspaces
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi pmscorca,

AFAIK, current define dynamic data masking seems not support to add conditions. You may need to create function or policies to control this feature status based on specific conditions or try to use column-level security to control the column display based on conditions.

In addition, you can also take a look at the official document define dynamic data masking part if helps:

Dynamic data masking in Synapse Data Warehouse - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Shneg

pmscorca's avatar
pmscorca
Kudo Kingpin
2 years ago

Hi, it seems that the dynamic data masking and the column-level security features don't allow to implement a conditional data masking respect to another column, isn't it?

Does it exist another manner to solve a such issue? Thanks

    • pmscorca's avatar
      pmscorca
      Kudo Kingpin
      2 years ago

      Hi, it seems that using a security policy I couldn't satisfy the business requirement. Thanks