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 multi-cluster warehouses. It’s still disabled by default for single-cluster 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 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.

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

Ref: 2373