A Data Engineer is reviewing Python data-pipeline code that dynamically scales warehouse HOL_WH:
What impact does the WAIT_FOR_COMPLETION clause have on the pipeline?
WAIT_FOR_COMPLETION
With WAIT_FOR_COMPLETION = TRUE, Snowflake blocks the return of the ALTER WAREHOUSE command until the warehouse resize has finished provisioning all compute resources. This ensures the enlarged warehouse is fully provisioned before the pipeline continues. Snowflake ALTER WAREHOUSE documentation
WAIT_FOR_COMPLETION = TRUE
ALTER WAREHOUSE
Community Discussion