I want to export >= 1K rows in a CSV file

Question

On Azure Synapse, I can't find the option to download the full results in a CSV file.

By default I can only export only the first 1000 rows. How can I download all from Azure Synapse without writing more code?

Answer 1

You can save your dataframe to a blob storage as CSV (configure the Blob linked service before) and the download it.

Here is what you need to do in this thread : https://stackoverflow.com/questions/72877473/export-more-than-1000-rows-from-azure-synapse-into-csv