SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ51

VerifiedDesign and Manage Snowflake Resources and Performance

A Data Engineer is reviewing Python data-pipeline code that dynamically scales warehouse HOL_WH:

Question Image

What impact does the WAIT_FOR_COMPLETION clause have on the pipeline?

Explanation

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

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!