topic Temporary views no longer working for Share Compute in Data Engineering

Temporary views no longer working for Share Compute

MarcusC — Tue, 30 Apr 2024 10:29:12 GMT

If I do this

%sql

create or replace temporary view myview

select * from silver.<schema>.<table>;

SHOW VIEWS;

select * from myview;
It works. But if I do the same on a Shared Compute it fails with
[TABLE_OR_VIEW_NOT_FOUND] The table or view `myview` cannot be found.

West Europe. Unity Catalog.

Re: Temporary views no longer working for Share Compute

Ajay-Pandey — Tue, 30 Apr 2024 10:44:05 GMT

Hi @MarcusC
Yes, for west Europe there is issue with temp view, I think this will be resolved soon.

Re: Temporary views no longer working for Share Compute

MarcusC — Tue, 30 Apr 2024 10:47:43 GMT

Thank you for that answer. Where can I find more info about this?

Re: Temporary views no longer working for Share Compute

Aviral-Bhardwaj — Tue, 30 Apr 2024 12:47:42 GMT

temp view will be deleted if cluster will stop as far as I know

Re: Temporary views no longer working for Share Compute

jose_gonzalez — Tue, 30 Apr 2024 23:49:37 GMT

which DBR version are you using?

Re: Temporary views no longer working for Share Compute

MarcusC — Wed, 01 May 2024 11:05:51 GMT

14.X and 15. It seems like Databricks fixed this problem an hour ago. Just works now. Oh, well.