Hi @y_sanjay ,

I guess that is somehow related to how sessions are managed within SQL Editor. For instance when I ran following queries in SQL Editor all at once it worked and I've got 3 result sets:

1) First result set with OK status - which means that my view was successfuly created

2) Second result set associated with my SELECT * FROM employees view

3) And the last one associated with SHOW VIEWS;

Now, when I try to execute this code one statement at the time I've got the same error as you:

Now, in the documentation they mentioned that temporary views are visible only to the session that created them and are dropped when the session ends. So that could suggest that in SQL Editor every query rans in new session or there is some kind of bug.

Because if I try to execute the same kind of code on the same kind of compute within notebook - there's no such an issue: