Databricks

Kody_Devl · ‎05-10-2022

Hi All

Does anyone have some code or example of how to export my Databricks SQL results directly to an existing spreadsheet?

Many Thanks

Kody_Devl

Kaniz · ‎05-18-2022

Hi @Ross Crill , There's a similar thread here - https://community.databricks.com/s/question/0D53f00001HKHqPCAX/how-can-i-export-a-result-of-a-sql-qu...

Now within the Databricks SQL interface (within the SQL editor), you can actually download the full results as an Excel file. Just make sure to uncheck "LIMIT 1000" and then click the download button under "..." in the bottom left:

View solution in original post

Kaniz · ‎05-18-2022

Hi @Ross Crill , There's a similar thread here - https://community.databricks.com/s/question/0D53f00001HKHqPCAX/how-can-i-export-a-result-of-a-sql-qu...

Now within the Databricks SQL interface (within the SQL editor), you can actually download the full results as an Excel file. Just make sure to uncheck "LIMIT 1000" and then click the download button under "..." in the bottom left:

Anonymous · ‎06-24-2022

Hey there @Ross Crill

Hope all is well!

Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? It would be really helpful for the other members too.

We'd love to hear from you.

Thanks!