https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21465#M14636 Wed, 23 Jun 2021 14:11:30 GMT User16826992945 2021-06-23T14:11:30Z https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21465#M14636 Wed, 23 Jun 2021 14:11:30 GMT https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21465#M14636 User16826992945 2021-06-23T14:11:30Z https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21466#M14637 <P>I believe it's due to limitation in Redash's legacy architecture (which was acquired by Databricks). Hence Databricks is doing great efforts in increasing this threshold (was originally 20K), so with patience it will get to close to 1 Million. In the meantime, it's recommended to run aggregation/reduction operations on your data.</P> Fri, 25 Jun 2021 22:32:32 GMT https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21466#M14637 Mooune_DBU 2021-06-25T22:32:32Z https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21467#M14638 <P>@Amine El Helou​&nbsp; when this limit will be lifted? my users won't switch from SSMS to dbx sql unless they can see all results set in UI ( which sometimes is more than 10mm rows) </P> Wed, 11 May 2022 20:42:13 GMT https://community.databricks.com/t5/data-engineering/why-is-the-current-limit-for-rows-returned-in-databricks-sql-64k/m-p/21467#M14638 prasadvaze 2022-05-11T20:42:13Z