One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?

The correct answer is B. 2 days. Snowflake's default value for the STATEMENT_TIMEOUT_IN_SECONDS parameter is 172,800 seconds, which equals exactly 2 days (48 hours). After this duration, Snowflake automatically cancels the query. This parameter can be configured at three levels: account level, warehouse level, a

Performance Optimization

Question

Options

A14 hours
B2 days
C2 hours
D24 hours

How the community answered

(39 responses)

A
3% (1)
B
90% (35)
C
5% (2)
D
3% (1)

Explanation

Snowflake's default value for the STATEMENT_TIMEOUT_IN_SECONDS parameter is 172,800 seconds, which equals exactly 2 days (48 hours). After this duration, Snowflake automatically cancels the query. This parameter can be configured at three levels: account level, warehouse level, and session level - with the most specific level taking precedence. For example, setting a lower timeout at the warehouse level overrides the account default. This default of 2 days is intentionally generous to accommodate large batch or analytical workloads, but administrators should tune it based on workload expectations to prevent runaway queries from consuming resources indefinitely.

Topics

#Query Timeout#Snowflake Limits#Long Running Queries#Query Execution

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice