What is the default timeout in hours for Snowflake statements (STATEMENT_TIMEOUT_IN_SECONDS)?

• A. 1 hour
• B. 10 hours
• C. 24 hours
• D. 48 hours

Answer: (D)

Snowflake limits how long a single statement can run with a per-statement timeout. The default value for STATEMENT_TIMEOUT_IN_SECONDS is 172,800 seconds, which equals 48 hours. So, by default, a statement can run for up to 48 hours before Snowflake cancels it. This long default helps accommodate very large or long-running operations without timing out prematurely. If you need quicker feedback, you can reduce this timeout by setting STATEMENT_TIMEOUT_IN_SECONDS to a smaller value (remember the unit is seconds; convert hours to seconds as needed, e.g., 1 hour = 3,600 seconds).