245 votesTony Liu commented
I'm a PM at Databricks. We understand this is a huge pain point. We're prioritizing features for the rest of the year and this is high on the list. Stay tuned for an update.
If you are a Chrome user, some people use Dark Reader (https://chrome.google.com/webstore/detail/dark-reader/eimadpbcbfnmbkopoojfekhnkhdbieeh/related?hl=en-US). This might serve your needs in the interim.
7 votesTony Liu commented
Hi Evgenii, next to the download to csv button is a caret dropdown. There is an option to download full results. However this is still capped at ~1 million rows. For really large files we recommend that you write the file to DBFS.