Delta Live Tables Unity Catalog Insufficient Permissions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2024 09:13 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2024 09:29 AM
I have also tried granting all permissions on the schema to myself and to all users and neither helped