New Browser experience does not have a way to export the entire results of a query.
Jon Bristow
I know the reason the old one let me is because it downloaded them all into memory, but I still would like a way to download the entire query results without loading a different app.
Gregory King
Jon Bristow Hey Jon, it's a bit of a workaround - but you could temporarily up the limit in settings to allow more results to be returned to the client.
You're right in that this was a conscious design choice in new Browser to no longer risk killing the web browser by returning and/or rendering unlimited returns.
We considered adding a "download full" results option, but in theory at least it could be downloading your entire database, which is not something we'd want to support. We could add a hard limit to that, but then that could be hard to explain. Keen to hear how well the workaround works for you for now. Thanks for taking the time to post!
Jon Bristow
Gregory King It doesn't work for me for 2 reasons:
1) I'm trying to pull 500k+ rows at a time and keeping track of paging is a bit of a nightmare in the console.
2) I lack a good way to get temporary credentials to do this in a jupyter notebook. I have to use long-lived credentials that I don't like having on my dev machine. (I would prefer to do this programmatically like AWS RDS/RedShift, if possible.
On top of this, I think my normal limit of 5000 is a good default for previewing if my query is working/performing like I intended.
I've been having trouble with profile on extremely large resultset queries as well, but I'll create a separate thread when I remember to capture the error messages