topic Re: Error - Data Masking in Get Started Discussions

Error - Data Masking

FaizH — Wed, 17 Jul 2024 03:50:01 GMT

Hi,

I was testing masking functionality of databricks and got the below error:

java.util.concurrent.ExecutionException: com.databricks.sql.managedcatalog.acl.UnauthorizedAccessException:
PERMISSION_DENIED: Query on table dev_retransform.uc_lineage.test_users_1
with row filter or column mask requires the SINGLE USER ACCESS privilege to be accessible from assigned clusters.

Below are the steps I followed in the notebook:

1. First I created this function

CREATE or REPLACE FUNCTION price_mask(price STRING)

RETURN CASE WHEN is_member('HumanResourceDept') THEN price ELSE '***-**-****' END;
2. I created this table

CREATE TABLE test_users_1 (

name STRING,

price FLOAT MASK price_mask);

3. Before inserting any data, I executed this query select * from dev_retransform.uc_lineage.test_users_1, and got the error highlighted in the screenshot below.

Where I need to give access? When I create a table without this function, I don't get any error.

Re: Error - Data Masking

szymon_dybczak — Wed, 17 Jul 2024 08:32:05 GMT

Hi @FaizH ,

Are you using single user compute by any chance?

Because of you do there is following limitation:

Single-user compute limitation

Do not add row filters or column masks to any table that you are accessing from a single-user cluster. During the public preview, you will be unable to access tables from a single user cluster if a filter or mask has been applied.

Re: Error - Data Masking

FaizH — Wed, 17 Jul 2024 21:03:17 GMT

Thanks for your reply. I use Access Mode as Shared instead of Single User for a cluster and it worked.