Warehouses: Enable QAS by default for all warehouse types with scale factor 8 (Pending)¶

This behavior change applies to the Query Acceleration Service (QAS) feature for standard warehouses, including single-cluster and multi-cluster warehouses.

Warehouse creation for standard warehouses behaves as follows:

Before the change:

QAS is enabled by default when creating new Gen2 and multi-cluster warehouses. It’s still disabled by default for single-cluster Gen1 warehouses (see Warehouses: Enable QAS by default for newly created Gen2 and multi-cluster warehouses).

When Snowflake automatically enables QAS at warehouse creation time, the default QUERY_ACCELERATION_MAX_SCALE_FACTOR is 2. When you explicitly enable QAS in a CREATE WAREHOUSE or ALTER WAREHOUSE statement, the default is 8.

After the change:

QAS is enabled by default when creating new standard warehouses of all types. That includes single-cluster warehouses (Gen1 and Gen2) and multi-cluster warehouses.

When Snowflake automatically enables QAS at warehouse creation time, the default QUERY_ACCELERATION_MAX_SCALE_FACTOR is 8 for all standard warehouse types, unless you explicitly set the property in CREATE WAREHOUSE or ALTER WAREHOUSE.

Snowpark-optimized warehouses are the exception: QAS is not enabled by default when you create a Snowpark-optimized warehouse.

Altering an existing warehouse does not enable QAS by default or turn it off if it’s already enabled. For example, the following operations don’t enable QAS:

• Altering a single-cluster warehouse to multi-cluster does not enable QAS.
• Altering the minimum or maximum cluster count does not enable QAS.
• Altering the multi-cluster warehouse scaling policy from economy to standard (or vice versa) does not enable QAS.
• Altering a Gen1 warehouse to Gen2 does not enable QAS.

This change is being made to enable more optimization opportunities across standard warehouse types and to unify QAS defaults.

Ref: 2373