Feature Request: Option to donwload result data

[gntpet]

At the moment, result set is limited to default 5000 rows and it could be changed by setting "Max Table Rows" setting. Having this limitation makes total sense, since you don't want to get entire dataset into the screen by default.
But sometimes you want to get full dataset just to the screen, or save it to Excel.

It would be nice to have:

• option 1: to have additional command to "Run Cell (fulldataset)", which would ignore "Max Table Rows" and return all data. Then you could save your results into CSV or Excel.
• option 2: to change save Excel functionality, to export full dataset by default.

Best Regards, Gintautas

[andrwo]

I would like to second this request. In SSMS, there is a "query to file" directly, that we can use to export large datasets without having to render everything. This is simply not available or feasible for extra-large datasets for ADS (as far as I know) where everything needs to come on screen first?

I am in a situation where I need to run my env in Linux and I have to hunt for a Windows machine to run SSMS to do some large data export to files all the time.