cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Temporary views no longer working for Share Compute

MarcusC
New Contributor II

If I do this

%sql
create or replace temporary view myview
as
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.
1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

5 REPLIES 5

Ajay-Pandey
Esteemed Contributor III

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

MarcusC
New Contributor II

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

Aviral-Bhardwaj
Esteemed Contributor III

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

jose_gonzalez
Moderator
Moderator

which DBR version are you using? 

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