cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Delta Live Tables Unity Catalog Insufficient Permissions

dadrake3
New Contributor II

I am receiving the following error when I try to run my DLT pipeline with unity catalog enabled.

```
raise Py4JJavaError( py4j.protocol.Py4JJavaError: An error occurred while calling o950.load. : org.apache.spark.SparkSecurityException: [INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have permission SELECT on any file. at com.databricks.sql.acl.Unauthorized.throwInsufficientPermissionsError(PermissionChecker.scala:358)

```

I have run this pipeline before and it has been successful however I sometimes receive this error when triggering it. It is not consistent when I do and dont receive this error. I also tried renaming the tables and recreating the pipeline to no avail. 

 

 

 

1 REPLY 1

dadrake3
New Contributor II

I have also tried granting all permissions on the schema to myself and to all users and neither helped

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now