Limit on number of result rows displayed on databricks SQL UI

[prasadvaze]

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

[User16765136105 · Accepted solution]

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.

[prasadvaze]

Didn't get chance to contact our dbx rep yet​

[prasadvaze]

Thanks Andrew​

[bigkahunaburger]

its flagged as having a solution?!?!

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

[vsrmerc]

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