- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 08:50 PM
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
2. I created this table
Where I need to give access? When I create a table without this function, I don't get any error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 01:32 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 02:02 PM - edited 07-17-2024 02:03 PM
Thanks for your reply. I use Access Mode as Shared instead of Single User for a cluster and it worked.