Snowflake Gen2 Warehouses: Blazing Fast Performance, Now Available on All 3 Clouds Across Expanded Regions
Since Snowflake’s founding in 2012, we have striven to be the market leader in fast performance for all workloads and continue to iterate rapidly to automatically improve by doing the heavy lifting on behalf of our customers. Our philosophy is simple: Our customers’ success is our success.
In 2012, Snowflake revolutionized the data world with our virtual warehouses that had automated cluster management, maintenance, upgrades and regular performance improvements — all without any downtime — for a truly easy-to-use service. In 2023, we introduced Snowpark Optimized warehouses, which allowed data scientists and data engineers to run large and memory-intensive machine learning (ML) training jobs and native code that relies on custom packages via Snowpark. Most recently at Snowflake Summit in June, we announced the general availability of Standard Warehouse - Generation 2 (Gen2) (in limited clouds and regions), an updated version of Snowflake’s current Standard Warehouse (Gen1) that has upgraded hardware and additional performance enhancements. We are excited to announce that Gen2 is now generally available across all three clouds — AWS, Microsoft Azure and Google Cloud Platform (GCP) — across an expanded set of regions.
With the upgraded hardware and additional performance improvements, Gen2 has delivered 2.1x faster performance for core analytics workloads on Snowflake tables over the last 12 months, ending May 2, 2025.
Furthermore, customers are seeing even bigger improvements on Gen2 for Data Manipulation Language (DML) (especially DELETE, UPDATE and MERGE) operations, data intensive analytics queries with large table scans and complex aggregations. In fact, as of May 2, 2025, Snowflake has delivered up to 4.4x faster performance for DELETE, UPDATE and MERGE DML operations, as compared to Standard Warehouses. Learn more about the DML innovations that have been incorporated into Gen2.
Hear from our customers and partners
SELECT, a Snowflake partner that helps customers with advanced optimization and cost management, evaluated Gen2 across several workloads and found substantial point-in-time performance improvements of 46% for select queries and 49% for filtered DML, as compared to Standard Warehouses.
Customers like AppFolio have seen significant performance improvements using Gen2:
At AppFolio, our team is dedicated to delivering timely, organization-wide insights, a commitment upheld by our data refresh SLAs. As data volumes and sources rapidly expanded—each bringing unique complexities and data freshness requirements—maintaining these standards became increasingly challenging, often demanding intricate processes and occasional manual intervention. Now, with Gen 2 warehouses, we've achieved a significant performance boost. This not only allows us to consistently meet our SLAs with ease, but it also empowers our team to focus on generating greater strategic business value.
Ryan D'Souza
Get started with Gen2 warehouses today
You can easily create a Gen2 warehouse using the CREATE WAREHOUSE command or in Snowsight.
In addition to creating new Gen2 warehouses, it is super easy to upgrade an existing standard Gen1 warehouse to Gen2.
CREATE OR REPLACE WAREHOUSE gen1_to_gen2_wh
WAREHOUSE_SIZE = XSMALL;
ALTER WAREHOUSE gen1_to_gen2_wh SUSPEND;
ALTER WAREHOUSE gen1_to_gen2_wh
SET RESOURCE_CONSTRAINT = STANDARD_GEN_2;
ALTER WAREHOUSE gen1_to_gen2_wh RESUME;To learn more about Gen2, please refer to our documentation.
Author
