Databricks SQL - How to get all the rows (more than 1000) in the first run?

Question

Currently, in Databricks if we run the query, it always returns 1000 rows in the first run. If we need all the rows, we need to execute the query again.

In the situations where we know that we need to download full data(1000+ rows), is there a turn around way to execute the query to get all the rows in the first run without re-executing the query?

Answer 1

There should be a down arrow next to the download button which allows you to Download full results. Are you seeing that in your interface? (Source)