A company stores customer PII data in a Unity Catalog table. The data governance team requires that only users in the `compliance_team` group can see the full SSN column; all other users should see the column masked as `***-**-XXXX`. Which Unity Catalog feature implements this requirement?

Question

Accepted Answer

B. Column masks on the SSN column. Column masks in Unity Catalog apply a masking function to a specific column at query time. Users in the `compliance_team` group see the full value; all other users see the masked value. Row filters filter entire rows, not column values. Creating a separate masked view is a manual alternative that does not dynamically enforce masking based on the querying user's group membership at the table level. Partitioning by SSN would expose the values through partition metadata.

A company stores customer PII data in a Unity Catalog table. The data governance team requires that only users in the `compliance_team` group can see the full SSN column; all other users should see the column masked as `*--XXXX`. Which Unity Catalog feature implements this requirement?

Related Questions

Discussion

A company stores customer PII data in a Unity Catalog table. The data governance team requires that only users in the compliance_team group can see the full SSN column; all other users should see the column masked as ***-**-XXXX. Which Unity Catalog feature implements this requirement?

Related Questions

Discussion

A company stores customer PII data in a Unity Catalog table. The data governance team requires that only users in the `compliance_team` group can see the full SSN column; all other users should see the column masked as `*--XXXX`. Which Unity Catalog feature implements this requirement?