How to increase max rows download in csv (not retrieval but download)

[Nathandrake01]

I am unable to download more than 1000 rows (though table has more than that, even the display is more than that).

How to do it. Please mention the file name to change (if any).

[willbarrett]

@Nathandrake01 if you're downloading via SQL Lab, you'll want to set a LIMIT on the query. Queries without LIMITs are automatically limited to the value of DEFAULT_SQLLAB_LIMIT - providing a larger LIMIT inside the query text will override that setting.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[qinlz-1]

@willbarrett Download via chart query