Which snowflake parameter limits the number of iterations

Which snowflake parameter limits the number of iterations
A . MAX_RECURSIONS
B. MAX_ITERATIONS
C. MAX_LOOP

View Answer

Answer: A

Explanation

Recursive CTE Considerations

Potential for Infinite Loops

In theory, constructing a recursive CTE incorrectly can cause an infinite loop. In practice, Snowflake prevents this by limiting the number of iterations that the recursive clause will perform in a single query. The MAX_RECURSIONS parameter limits the number of iterations.

To change MAX_RECURSIONS for your account, please contact Snowflake Support.