What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Question

Jose Walter · Accepted Answer

It does not return from the command until the warehouse has finished changing its size.

Jose Walter · Answer

The warehouse size does not change until all queries currently running in the warehouse have completed.

Jose Walter · Answer

The warehouse size does not change until all queries currently in the warehouse queue have completed.

Jose Walter · Answer

The warehouse size does not change until the warehouse is suspended and restarted.

List of questions