topic Save a Visual Query results as a Table in Lakehouse SQL endpoint in Data Engineering

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

Luci7 — Tue, 13 Jun 2023 15:54:24 GMT

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? I tried everything and I cannot because this option is not available. I can only see "Download or Visualize".

I can only save the results as a table, if I write a SQL query because it gives me this option:

Thank you very much for any assistance you could provide.

Best regards.

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

HimanshuS-msft — Tue, 13 Jun 2023 22:56:56 GMT

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

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

Luci7 — Wed, 14 Jun 2023 07:28:34 GMT

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