<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Gandharva</title>
    <description>The latest articles on DEV Community by Gandharva (@heygandharva).</description>
    <link>https://dev.to/heygandharva</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4254910%2Ff5b5998d-6c3d-4472-8e04-8c084ac6fa33.png</url>
      <title>DEV Community: Gandharva</title>
      <link>https://dev.to/heygandharva</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/heygandharva"/>
    <language>en</language>
    <item>
      <title>PSA: check auto_stop_mins on your SQL warehouses if you deploy with bundles</title>
      <dc:creator>Gandharva</dc:creator>
      <pubDate>Fri, 20 Nov 2026 05:34:52 +0000</pubDate>
      <link>https://dev.to/heygandharva/psa-check-autostopmins-on-your-sql-warehouses-if-you-deploy-with-bundles-38g9</link>
      <guid>https://dev.to/heygandharva/psa-check-autostopmins-on-your-sql-warehouses-if-you-deploy-with-bundles-38g9</guid>
      <description>&lt;h4&gt;
  
  
  If you create SQL warehouses through Declarative Automation Bundles and leave out auto_stop_mins, the default isn’t what you get in the UI. Bundles default to 10 minutes for Serverless and 120 for Pro/Classic. The UI defaults to 10 for Serverless and 45 for Pro/Classic.
&lt;/h4&gt;

&lt;p&gt;Apparently someone deployed a Serverless warehouse with a bundle, didn’t set the field, and got 120 minutes instead of the 10 the docs list. That hurts if you have a bunch of short scheduled alerts, because each one wakes the warehouse up and then it just sits there until auto-stop kicks in.&lt;/p&gt;

&lt;p&gt;A few other things from the same writeup:&lt;/p&gt;

&lt;p&gt;The Serverless UI won’t go below 5 min auto-stop, but the API, CLI and bundles accept 1 (databricks warehouses edit  --auto-stop-mins 1). Pro and Classic bottom out at 10.&lt;/p&gt;

&lt;p&gt;A single slow or spilling query points to warehouse size. Queries waiting at capacity point to max clusters. Peak queued queries above zero doesn’t tell you which one on its own.&lt;/p&gt;

&lt;p&gt;Power BI DirectQuery can send a query on every dashboard interaction. If the business only needs fresh data every few minutes, Import or Hybrid mode cuts a lot of that.&lt;/p&gt;

&lt;p&gt;DBU rate alone is misleading. In one AWS US East example, Serverless is about $0.70/DBU, Pro $0.55 and Classic $0.22, but Pro and Classic bill infrastructure on top.&lt;/p&gt;

&lt;p&gt;Is anyone running a 1-minute auto-stop on serverless for scheduled jobs? Do the cold starts bother you?&lt;/p&gt;

&lt;p&gt;Full article : &lt;a href="https://select.dev/blog/serverless-sql-warehouse-cost-optimization" rel="noopener noreferrer"&gt;https://select.dev/blog/serverless-sql-warehouse-cost-optimization&lt;/a&gt;&lt;/p&gt;

</description>
      <category>ai</category>
      <category>architecture</category>
      <category>database</category>
      <category>discuss</category>
    </item>
  </channel>
</rss>
