https://community.databricks.com/t5/warehousing-analytics/1-min-auto-termination/m-p/65534#M1259 <P>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.</P><P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1min.png" style="width: 900px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6924iCC04FAE825EC36BF/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="1min.png" alt="1min.png" /></span></STRONG></P> Thu, 04 Apr 2024 18:29:40 GMT Hubert-Dudek 2024-04-04T18:29:40Z https://community.databricks.com/t5/warehousing-analytics/1-min-auto-termination/m-p/65534#M1259 <P>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.</P><P><STRONG><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1min.png" style="width: 900px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6924iCC04FAE825EC36BF/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="1min.png" alt="1min.png" /></span></STRONG></P> Thu, 04 Apr 2024 18:29:40 GMT https://community.databricks.com/t5/warehousing-analytics/1-min-auto-termination/m-p/65534#M1259 Hubert-Dudek 2024-04-04T18:29:40Z https://community.databricks.com/t5/warehousing-analytics/1-min-auto-termination/m-p/65538#M1260 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/25346">@Hubert-Dudek</a>&nbsp;, Hope you are doing well!&nbsp;</P> <P>Could you please clarify more on your ask here?&nbsp;</P> <P>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&nbsp;to the specified number of minutes. You can do this manually or from the Databricks API as well.&nbsp;</P> <P>Please refer to these documents for the same:&nbsp;</P> <P>UI:&nbsp;<A href="https://docs.databricks.com/en/compute/sql-warehouse/create.html#create-a-sql-warehouse" target="_blank">https://docs.databricks.com/en/compute/sql-warehouse/create.html#create-a-sql-warehouse</A></P> <P>API :&nbsp;<A href="https://docs.databricks.com/api/workspace/warehouses/create" target="_blank">https://docs.databricks.com/api/workspace/warehouses/create</A></P> <P>Please let me know if this helps and leave a like if this information is useful, followups are appreciated.<BR />Kudos<BR />Ayushi</P> Thu, 04 Apr 2024 20:07:45 GMT https://community.databricks.com/t5/warehousing-analytics/1-min-auto-termination/m-p/65538#M1260 Ayushi_Suthar 2024-04-04T20:07:45Z