topic Re: Permission denied on schema evolution view in Data Engineering

Permission denied on schema evolution view

Sinkrad — Mon, 10 Feb 2025 15:14:32 GMT

Hey Databricks community,

We are registering views in Databricks with schema evolution, however these views fail when a user (other than the owner) is the first to query the view after the schema change.

PERMISSION_DENIED: User is not an owner of Table '<domain>.<schema>.<view>'.

I had a look in the access log and it appears that if someone queries the view after a schema change, the view definition (columns) is updated. This update action can only be performed by the owner of the view and hence if any other user queries the view, the above error is thrown.

I was wondering if someone already encountered this error and found a solution

Example code leading to the error

create table <catalog>.<schema>.<table> location '<external storage location>' create view <catalog>.<schema>.<view> with schema evolution as select * from <catalog>.<schema>.<table> # <-- Make any schema change to the delta table in the external location Select * from <catalog>.<schema>.<view> # Perform this query with another identity than the one creating the table

Re: Permission denied on schema evolution view

Alberto_Umana — Mon, 10 Feb 2025 15:41:04 GMT

Hi @Sinkrad,

There is an internal case about this: ES-1260035, and a fix is going to be out for this quarter. The behavior where only the view owner can update the view definition after a schema change is not intended. It is expected that the view should automatically handle schema evolution without requiring the view owner to perform the first query.

Re: Permission denied on schema evolution view

jim_thorstad — Fri, 28 Mar 2025 14:11:22 GMT

Please note that ES-1260035 was marked RESOLVED on January 3, and a new ticket ES-1345582 - Issue with using a view WITH SCHEMA EVOLUTION remains open for resolving the issue. It's my understanding the new work is planned for DBR 17.0 in the May timeframe but dates can change.

Re: Permission denied on schema evolution view

vinnyt — Fri, 19 Sep 2025 00:08:08 GMT

Hi, do you have any update on the status of ES-1345582? Hitting the error where the owner must query the schema evolution view after a schema change on a serverless SQL warehouse.