A data team needs to ensure that users outside the `finance_admin` group see only the last 4 digits of an `account_number` column (displayed as `****XXXX`), while `finance_admin` members see the full value. Which Unity Catalog feature implements this at query time?

Question

Accepted Answer

B. Column masks applied to the `account_number` column. Column masks in Unity Catalog attach a SQL masking function to a column. The function executes dynamically at query time and returns a value based on the caller's identity — using functions such as `current_user()` or `is_account_group_member()`. Members of `finance_admin` receive the full value; all others receive the masked representation.

A data team needs to ensure that users outside the `finance_admin` group see only the last 4 digits of an `account_number` column (displayed as `****XXXX`), while `finance_admin` members see the full value. Which Unity Catalog feature implements this at query time?

Related Questions

Discussion

A data team needs to ensure that users outside the finance_admin group see only the last 4 digits of an account_number column (displayed as ****XXXX), while finance_admin members see the full value. Which Unity Catalog feature implements this at query time?

Related Questions

Discussion

A data team needs to ensure that users outside the `finance_admin` group see only the last 4 digits of an `account_number` column (displayed as `****XXXX`), while `finance_admin` members see the full value. Which Unity Catalog feature implements this at query time?