title: Databricks SQL - How to get all the rows (more than 1000) in the first run?
body: <p>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.</p>
  <p>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?</p>