Skip to main content

Scale Down Size

The size the Snowflake Warehouse can be scaled down 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 end of each batch when Scale Down is enabled. The value can be overridden per batch through a Settings override.

When to Change This Setting​

Keep a small size (the default XSMALL) so the warehouse idles at minimal cost between batches; choose a larger size when post-batch workloads still need compute.

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

Notes​

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