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. 

 

 

 

dadrake3
New Contributor II

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