Azuredatastudio: SQL query to CSV export only downloads 5000 rows

Created on 14 May 2020  路  2Comments  路  Source: microsoft/azuredatastudio




  • Azure Data Studio Version:

Steps to Reproduce:

  1. SELECT * FROM some_table only returns 5000 rows in a notebook and I can only download 5000 rows.

How do I increase the limit? I've tried googling and looking through the settings and the documents, but I can't find an answer. Help would be appreciated

Area - Notebooks Bug Done

Most helpful comment

We have a setting that dictates this max value:

image

We've set this initially because performance on a notebook with many cells and many outputs (such as tables) can cause performance degradation when a notebook gets fairly large (say, 50MB+).

Feel free to play with this, and please keep the feedback coming!

All 2 comments

We have a setting that dictates this max value:

image

We've set this initially because performance on a notebook with many cells and many outputs (such as tables) can cause performance degradation when a notebook gets fairly large (say, 50MB+).

Feel free to play with this, and please keep the feedback coming!

Closing this for now. Please feel free to reactivate if you encounter any issues!

Was this page helpful?
0 / 5 - 0 ratings

Related issues

squillace picture squillace  路  3Comments

kburtram picture kburtram  路  3Comments

haydnlj picture haydnlj  路  3Comments

stevenreddie picture stevenreddie  路  3Comments

Ungerfall picture Ungerfall  路  3Comments