@KVNARK .​ Hi, I could see this question is already answered. But this is something I found, Please check.

By default, Databricks SQL notebooks limit the number of rows displayed to 1,000. However, you can increase this limit to display more than 1 Lakh (100,000) rows by changing the configuration setting for spark.databricks.query.displayMaxRows

.

To change the configuration setting, follow these steps:

1. In the Databricks workspace, navigate to the cluster that you're using for your notebook.
2. Click on the "Advanced Options" tab.
3. In the "Spark" section, click on the "Edit" button next to "Spark Config".
4. Add the following configuration setting:
5. spark.databricks.query.displayMaxRows 10000 (or the desired maximum number of rows)
6. Click "Confirm" to save the configuration change.

Thanks,

Vignesh