hi @y_sanjay 

Thank you for reaching out.

Temporary views are only usable in the scope of the notebook or SQL session where you defined them, then  they are dropped after the session ends.  

You may want to use "SHOW VIEWS" instead that also shows temporary views, but again, in the same session to reflect the results; otherwise, it won't be visible.

I hope this helps!