Skip to main content

Scale Up

Determines whether BimlFlex scales up the Snowflake warehouse at the start of each batch pipeline. When set to Y, BimlFlex generates ALTER WAREHOUSE ... RESUME followed by ALTER WAREHOUSE ... SET WAREHOUSE_SIZE = {SnowflakeScaleUpSize} as the first activities in the batch, ensuring the warehouse is active and sized appropriately before any data loading begins. Set this to N if your warehouse is managed externally or you want to avoid the resume/resize overhead on warehouses that are already running.

Notes:

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is Y.
  • Depends on SnowflakeScaleUpSize to determine the target warehouse size.