Default Query Limit 1000

[Digan_Parikh]

Is there any way to change the 1000 for the display row limit at workspace, cluster and notebook level?

[Digan_Parikh · Accepted solution]

Yes this is possible but the changes need to occur at the shard level. Note, larger values may increase the likelihood of the webapp instability because it will load a lot of results. Please reach out to your Databricks contact for a detailed conversation.

[User16805453151]

This is simple in Databricks SQL, just uncheck LIMIT 1000 in the drop down.