cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

Querying view gives spurious error

PaulJones
New Contributor

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. 
1 REPLY 1

mnorland
Contributor

Are there DDL updates of the view going on?

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