Forum Discussion

Luci7's avatar
Luci7
Helper I
3 years ago

Save a Visual Query results as a Table in Lakehouse SQL endpoint

Hi all,   Working on MS Fabric, in the Lakehouse SQL endpoint, I created a Visual Query:     in this visual query, I am appending two tables. Is it possible to save the results as a Table?...
data engineering
HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
3 years ago

Hello Luci7 , 

Thanks for using the Fabric community .

I dont think you can do that , but you can use the "View SQL" Option the Visual Query and then paste the query in the "New SQL query " .

 



 

Thanks
HImansh

 

 

 

Luci7's avatar
Luci7
Helper I
3 years ago

Hello HimanshuS-msft and thank you for your help. I tried to do as you said, but when you append data_table and data_table (2) in your example, the "view SQL" only shows, for me, the SQL query of one table and not the new created appended table. Could you kindly see if you are able to reproduce this issue? 

 

Thank you very much!

Kind regards,

Luci