in Snowflake, Does resize an existing warehouse helps in improving the performance of a running query?

Question

in Snowflake, Does resize of an existing warehouse helps in improving the performance of a running query ?

score 1 · Answer 1 · answered Nov 08 '19 at 00:00

Resizing a running warehouse does not impact queries that are already being processed by the warehouse; the additional servers are only used for queued and new queries.

https://docs.snowflake.net/manuals/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out

score 0 · Answer 2 · answered Nov 08 '19 at 07:29

0

If your warehouse was severely undersized for the running query, you would be better off aborting that query, and rerunning it after the warehouse has been resized appropriately.

answered Nov 08 '19 at 07:29

HIlda Davies

141
2

in Snowflake, Does resize an existing warehouse helps in improving the performance of a running query?

2 Answers2