SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ56

Performance, Cost, and Resource Optimization

An Architect runs the following commands:

Question Image

The catalog_sales table is very large, and task_wh is an X-Small warehouse. The actual INSERT statement will take approximately 40 hours.

The Architect then runs the following command:

EXECUTE TASK insert_task;

For how long will the insert execute?

Explanation

USER_TASK_TIMEOUT_MS = 60000 limits one task run to 60 seconds. When both USER_TASK_TIMEOUT_MS and STATEMENT_TIMEOUT_IN_SECONDS are set, Snowflake uses the lowest non-zero timeout. The warehouse statement timeout is 300 seconds, so the task-level 60-second timeout applies.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!