Skip to main content

Scale Down

Determines if the Snowflake processing should scale down the Snowflake Warehouse at end of the Batch.

When enabled, the generated batch package ends with ALTER WAREHOUSE ... SET WAREHOUSE_SIZE = {Scale Down Size}, reducing the warehouse to a smaller size after the loads complete.

When to Change This Setting​

Keep the default Y to return the warehouse to an inexpensive size after each batch. Disable it when downstream processes rely on the warehouse remaining at its scaled-up size.

SettingInteraction
Scale Down SizeThe size applied at the end of the batch
Scale UpThe start-of-batch counterpart
Auto SuspendSuspends the warehouse after the scale-down statement

Notes​

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is Y.