Databricks SQL Warehouse does not scale down to 0

[edejong1980]

Hey Support Team,

We are experiencing an issue with our Databricks warehouse where the auto-stop feature does not seem to be working as expected. Despite setting an idle timeout, the warehouse continues running after the configured auto-stop time has passed. There are no running queries in the period when the warehouse stays at 1 running instance.

Here are the details:

Issue: The warehouse remains active even after the auto-stop time is reached.

Steps Taken:

- Verified the auto-stop configuration settings in the warehouse settings.

- Confirmed that the correct idle timeout value is set.

- Manually stopping the warehouse doesn't seem to be working also. After a certain time period, warehouse starts working again.

- There are no queries in the period when the SQL Warehouse becomes active.

Could you please assist in investigating this behavior? Let me know if you require any additional information, logs, or screenshots to help troubleshoot the problem.

Best.

Edwin and Shevket

[edejong1980]

We were able to diagnose and resolve the problem. The problem was caused due to a cube.js JDBC connection repeatedly connecting to our Databricks SQL Warehouse. Databricks SQL Warehouse does not scale down when there are repeated new connections made. We did this discovery by investigating our audit logs.