Skip to main content

Scale Down Size

The target warehouse size applied by the ALTER WAREHOUSE ... SET WAREHOUSE_SIZE statement generated at the end of each batch when SnowflakeScaleDown is set to Y. This value is typically set to a smaller size than SnowflakeScaleUpSize so that the warehouse idles at minimal cost between batch runs. Accepted values are XSMALL, SMALL, MEDIUM, LARGE, XLARGE, XXLARGE, XXXLARGE, and X4LARGE.

Notes:

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is XSMALL.
  • Only takes effect when SnowflakeScaleDown is set to Y.