Standard warehouses: Gen2 is the default generation (Pending)¶

Gen2 is the latest generation of standard warehouses, with improved performance for analytics and data engineering workloads. We recommend using it for new warehouses.

When you create a standard warehouse without specifying a GENERATION value, the default generation is changing.

Before the change:

The default generation for a new standard warehouse depends on the cloud service provider region and whether your organization was created after Gen2 support became available in that region. For organizations or regions where Gen2 isn’t the default, Snowflake creates a Gen1 standard warehouse.

After the change:

In regions where Gen2 is available, the default generation for all new standard warehouses is Gen2 (GENERATION = '2'). If you don’t specify the GENERATION clause when you create a standard warehouse, Snowflake creates a Gen2 standard warehouse. In regions where Gen2 isn’t available, the default remains Gen1. For a list of supported regions, see Region availability.

Existing Gen1 warehouses, whether running or suspended, remain Gen1 unless you explicitly change them.

Note

Currently, a CREATE OR ALTER command without a GENERATION clause on a Gen1 warehouse will change the warehouse to Gen2 if it performs an ALTER operation. To keep an existing warehouse as Gen1, include the clause GENERATION = '1' in the CREATE OR ALTER command.

X5LARGE and X6LARGE warehouse sizes don’t support Gen2. Warehouses created with those sizes default to Gen1.

Snowpark-optimized warehouses aren’t affected by this change. The GENERATION clause applies only to standard warehouses.

For more information, see Snowflake generation 2 standard warehouses.

Ref: 2250