1 min auto termination

[Hubert-Dudek]

SQL warehouse can auto-terminate after 1 minute, not 5, as in UI. Just run a simple CLI command. Of course, with such a low auto termination, you lose the benefit of CACHE, but for some ad-hoc queries, it is the perfect setup when combined with serverless.

[Ayushi_Suthar]

Hi @Hubert-Dudek , Hope you are doing well! 

Could you please clarify more on your ask here? 

However, from the above details, the SQL warehouse mentioned is auto-terminating after 1 minute of inactivity because the Auto stop is set to 1 minute. However, you can change this config to the specified number of minutes. You can do this manually or from the Databricks API as well. 

Please refer to these documents for the same: 

UI: https://docs.databricks.com/en/compute/sql-warehouse/create.html#create-a-sql-warehouse

API : https://docs.databricks.com/api/workspace/warehouses/create

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi