Skip to main content

Scale Up

Determines if the Snowflake processing should scale up the Snowflake Warehouse at the start of the Batch.

When enabled, the generated batch package starts with ALTER WAREHOUSE ... RESUME IF SUSPENDED followed by ALTER WAREHOUSE ... SET WAREHOUSE_SIZE = {Scale Up Size}, ensuring the warehouse is running and sized for the load before any processing begins.

When to Change This Setting​

Keep the default Y to resume and size the warehouse automatically at the start of each batch. Disable it when the warehouse is managed externally.

SettingInteraction
Scale Up SizeThe size applied at the start of the batch
Scale DownThe end-of-batch counterpart
WarehouseThe warehouse the statements target

Notes​

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