How would you determine the size of the virtual warehouse used for a task?
A.
Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
B.
Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
C.
If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
D.
Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
B
For queries in large-scale production environments, larger warehouse sizes (Large, X-Large, 2X-Large, etc.) may be more cost effective.
https://docs.snowflake.com/en/user-guide/warehouses-considerations
"Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. They are not as beneficial for improving the performance of slow-running queries or data loading. For these types of operations, resizing the warehouse provides more benefits."
Snowflake representative explained this here https://community.snowflake.com/s/question/0D50Z00009F8nPTSAZ/how-to-choose-the-right-virtual-warehouse-size-in-snowflake-for-your-workload
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
mandar_007
1 month agoMayuri917233
1 year, 6 months agoSV1122
1 year, 10 months agograbc
2 years, 9 months agoarpit_dataguy
2 years, 9 months agocorentin
2 years, 10 months ago