Querying view gives spurious error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 02:37 PM
When trying to query a view, my_view, we sometimes see a spurious error. This seems to occur after the table underlying the view has been updated. The error persists for a while and then it seems to fix itself.
Error running query: [42501] [Simba][Hardy] (35) Error from server: error code: '0' error message: 'org.apache.hive.service.cli.HiveSQLException: Error running query: [UNAUTHORIZED_ACCESS] com.databricks.sql.managedcatalog.acl.UnauthorizedAccessException: PERMISSION_DENIED: User is not an owner of Table 'my_view'. at org.apache.s'. (35) (SQLExecDirectW)
One hypothesis for this error is that: Databricks is occasionally trying to do something else in addition to running the query, like modifying some metadata, and that's what the actual permissions error comes from.
I was wondering if anyone has seen this before, or would have tips for how to investigate this further.
I was wondering if anyone has seen this before, or would have tips for how to investigate this further.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 03:30 PM
Are there DDL updates of the view going on?

