Skip to main content

Scale Down

Determines whether BimlFlex scales down the Snowflake warehouse at the end of each batch pipeline. When set to Y, BimlFlex generates ALTER WAREHOUSE ... SET WAREHOUSE_SIZE = {SnowflakeScaleDownSize} as a post-load activity, reducing the warehouse to a smaller size after all loads complete to minimize idle credit consumption. Set this to N if downstream processes rely on the warehouse remaining at full size after the batch finishes.

Notes:

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