topic Re: Limit on number of result rows displayed on databricks SQL UI in Data Engineering

Limit on number of result rows displayed on databricks SQL UI

prasadvaze — Wed, 11 May 2022 20:37:26 GMT

Databricks SQL UI currently limits the query results display to 64000 rows. When will this limit go away? Using SSMS I get 40MM rows results in the UI and my users won't switch to databricks SQL for this reason

Re: Limit on number of result rows displayed on databricks SQL UI

User16765136105 — Thu, 12 May 2022 22:39:41 GMT

Hi @prasad vaze - We do have a feature in the works that will increase this limit. If you reach out to your Databricks contact they can give you more details regarding dates and the preview.

Re: Limit on number of result rows displayed on databricks SQL UI

prasadvaze — Fri, 13 May 2022 21:41:36 GMT

Didn't get chance to contact our dbx rep yet

Re: Limit on number of result rows displayed on databricks SQL UI

prasadvaze — Fri, 13 May 2022 21:42:11 GMT

Thanks Andrew

Re: Limit on number of result rows displayed on databricks SQL UI

bigkahunaburger — Wed, 09 Apr 2025 02:47:45 GMT

its flagged as having a solution?!?!

nothing was done. nothing appears to have been done in the last 3 years...

Re: Limit on number of result rows displayed on databricks SQL UI

vsrmerc — Mon, 17 Nov 2025 17:47:15 GMT

want to understand the reason behind it. retrieving 500k records is not a problem, is it rendering over the http thats the problematic?