Skip to main content

Scale Up Size

The size the Snowflake Warehouse can be scaled up to.

Options: XSMALL, SMALL, MEDIUM, LARGE, XLARGE, XXLARGE, XXXLARGE, X4LARGE

The value is applied by the ALTER WAREHOUSE ... SET WAREHOUSE_SIZE statement generated at the start of each batch when Scale Up is enabled. The value can be overridden per batch through a Settings override.

When to Change This Setting​

Choose a larger size for heavy loads that benefit from more compute, and a smaller size for light workloads to limit credit consumption.

SettingInteraction
Scale UpEnables the start-of-batch resize that uses this size
Scale Down SizeThe size applied at the end of the batch

Notes​

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