cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Warehouse - Auto Stop not working

Digvijay_11
New Contributor

We have Azure Databricks - SQL Serverless Warehouse with Classic configuration. The config details shared in below snip.

Digvijay_11_3-1731482307233.png

 

As per the Auto Stop config, the Serverless warehouse should be stopped after 10 min of inactivity. However, when we were monitoring the cluser count, we observed that the cluster is always in running mode & it does not show as shut down. Sharing the image from the monitoring tab for the last 7 days & last 8 hours.

Digvijay_11_1-1731481623426.png

Last 8 Hours: As you can observe in below screenshot, the cluster should be shut down for duration of 3 to 6 am but the cluster count is always 1. 

Digvijay_11_2-1731481643294.png

#sqlwarehouse

 

1 REPLY 1

MuthuLakshmi
Databricks Employee
Databricks Employee

@Digvijay_11 

A dbsql warehouse can be triggered not only by a query from a JDBC/ODBC client but also by an idle session, as sessions are managed within the backend clusters. Clusters must be running to maintain these sessions, even before a query is submitted to the database.

You need to check if your JDBC client keeps on opening and closing empty sessions without actually submitting any queries.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group