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

Question

Philippe Chretien · Accepted Answer

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

Philippe Chretien · Answer

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

Philippe Chretien · Answer

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

Philippe Chretien · Answer

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

List of questions