cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Why is the current limit for rows returned in Databricks SQL 64K?

User16826992945
New Contributor
3 REPLIES 3

Mooune_DBU
Valued Contributor

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.

prasadvaze
Valued Contributor

@Amine El Helouโ€‹  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)

Anonymous
Not applicable
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.