How can we disable auto suspend on a warehouse?

• A. Explicitly select Never in the web interface
• B. Specify 0 in SQL
• C. Specify Null in SQL
• D. Set the auto suspend time to a long value

Answer: (A)

Auto suspend is the feature that stops a warehouse after a period of inactivity to save compute credits. To truly disable it, you need to tell Snowflake to never suspend by selecting Never for auto suspend in the web interface. This explicit setting ensures the warehouse stays on regardless of idle time. Using a numeric value in SQL isn’t equivalent: 0 or Null can map to default behavior or be interpreted differently across contexts, and setting a long value only delays suspension rather than preventing it entirely. So, choosing Never in the UI is the reliable way to keep the warehouse running.