Per Snowflake docs - Setting AUTO_SUSPEND to 0 or NULL is not recommended, unless your query workloads require a continually running warehouse. Note that this can result in significant consumption of credits (and corresponding charges), particularly for larger warehouses. In this case it would be reasonable to do as the scenario calls out a continuous query load. https://docs.snowflake.com/en/sql-reference/sql/create-warehouse
AUTO_SUSPEND = 0 means the virtual warehouse will not automatically suspend, making it ideal for a steady, uninterrupted workload. This configuration avoids execution lag caused by resuming a suspended warehouse.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MatthieuDN
3 months, 2 weeks agoc561a14
3 months, 2 weeks ago37ceea2
3 months, 2 weeks agopolzwed
3 months, 3 weeks agoMultiCloudIronMan
3 months, 3 weeks ago