Hello!
According to Databricks documentation on azure :
"On Databricks Runtime 15.3 and below, fine-grained access control on single user compute is not supported. Specifically:
- You cannot access a table that has a row filter or column mask.
- You cannot access dynamic views.
- To read from any view, you must have SELECT on all tables and views that are referenced by the view."
Well, I am using DBR 15.4 LTS and getting the following error message when running an optimize job (OPTIMIZE table name) on some tables that have a row filter:
Py4JJavaError: An error occurred while calling o388.sql. : java.util.concurrent.ExecutionException: com.databricks.sql.managedcatalog.UnityCatalogServiceException: [RequestId=d5be0519-**** ErrorClass=INVALID_PARAMETER_VALUE.ROW_COLUMN_ACCESS_POLICIES_NOT_SUPPORTED_ON_ASSIGNED_CLUSTERS] Query on table **** with row filter or column mask not supported on assigned clusters.
This is my job cluster configuration:
Can you please help me figure out when could possible cause such an error ?
Thanks a lot!