Snowflake X-Large warehouse cost
A X-Large Gen2 warehouse uses 21.6 credits an hour, so on Enterprise in AWS US East (Northern Virginia) it costs $64.80 an hour at $3.00 a credit, billed by the second. Below: its credits on each generation and cloud, its price on each edition and in every region, and the sizes either side.
Credits an hour
X-Large at a glance
- Gen1 standard
- 16
- Every cloud
- Gen2, AWS
- 21.6
- Gen2, Azure
- 20
- Gen2, Google Cloud
- 21.6
- Snowpark, 256 GB
- 24
An hour on each edition
In AWS US East (Northern Virginia), for 1 cluster, billed by the second. Gen2 credits are AWS's.
| Warehouse | Credits | Standard | Enterprise | Business Critical |
|---|---|---|---|---|
| Gen2 standard | 21.6 | $43.20 | $64.80 | $86.40 |
| Gen1 standard | 16 | $32.00 | $48.00 | $64.00 |
| Snowpark-optimized, 256 GB | 24 | $48.00 | $72.00 | $96.00 |
| Snowpark-optimized, 1 TB | 30 | $60.00 | $90.00 | $120 |
In each region
An hour on Enterprise, cheapest first, on Gen2 where the region sells it. Each region has its own page.
AWS
- US East (Northern Virginia)$64.80
- US East 2 (Ohio)$64.80
- US West (Oregon)$64.80
- AP Mumbai$64.80
- Africa (Cape Town) · Gen1$67.20
- EU (Zurich) · Gen1$74.40
- Canada Central$75.60
- Europe (Stockholm)$77.76
- Asia Pacific (Malaysia)$77.76
- Asia Pacific (Thailand)$77.76
- AP Singapore$79.92
- Asia Pacific (Jakarta)$79.92
- EU (Paris)$84.24
- EU Dublin$84.24
- EU Frankfurt$84.24
- Europe (London)$86.40
- Middle East (UAE)$86.40
- Asia Pacific (Seoul)$87.48
- AP Sydney$87.48
- Asia Pacific (New Zealand)$87.48
- AP Northeast 1 (Tokyo)$92.88
- Asia Pacific (Osaka)$92.88
- South America East 1 (São Paulo)$100
Azure
- East US 2 (Virginia)$60.00
- Central US (Iowa)$60.00
- East US$60.00
- Mexico Central$60.00
- South Central US (Texas)$60.00
- West US 2 (Washington)$60.00
- Central India (Pune)$60.00
- Canada Central (Toronto)$70.00
- Sweden Central$72.00
- Southeast Asia (Singapore)$74.00
- North Europe (Ireland)$78.00
- West Europe (Netherlands)$78.00
- UK South (London)$80.00
- UAE North (Dubai)$80.00
- Korea Central$81.00
- Australia East (New South Wales)$81.00
- Japan East (Tokyo)$86.00
- Switzerland North$93.00
Every size
- X-Small1 credits an hour on Gen1, 1.35 on Gen2
- Small2 credits an hour on Gen1, 2.7 on Gen2
- Medium4 credits an hour on Gen1, 5.4 on Gen2
- Large8 credits an hour on Gen1, 10.8 on Gen2
- X-Large16 credits an hour on Gen1, 21.6 on Gen2
- 2X-Large32 credits an hour on Gen1, 43.2 on Gen2
- 3X-Large64 credits an hour on Gen1, 86.4 on Gen2
- 4X-Large128 credits an hour on Gen1, 172.8 on Gen2
- 5X-Large256 credits an hour on Gen1, no Gen2
- 6X-Large512 credits an hour on Gen1, no Gen2
Questions
- How many credits does a Snowflake X-Large warehouse use?
- A X-Large uses 16 credits an hour as a Gen1 standard warehouse. As Gen2 it uses 21.6 on AWS, 20 on Azure and 21.6 on Google Cloud. Each cluster of a multi-cluster warehouse uses the same again.
- How much does a Snowflake X-Large warehouse cost an hour?
- In AWS US East (Northern Virginia), a X-Large Gen2 warehouse costs $43.20 an hour on Standard, $64.80 on Enterprise and $86.40 on Business Critical, for 21.6 credits an hour. Each region sets its own price for a credit, so the hour costs more or less there.
- What does a X-Large warehouse cost for 10 minutes?
- $10.80 on Enterprise in AWS US East (Northern Virginia): Snowflake bills by the second, so 10 minutes uses a sixth of the 21.6 credits an hour, 3.6 credits. Each start bills at least 60 seconds, $1.08, and the warehouse keeps billing until it suspends, 10 idle minutes by default.
- What does a Snowflake X-Large warehouse cost a month?
- Running queries 4 hours a day over 6 starts, 22 days a month, with the default auto-suspend, a X-Large Gen2 warehouse is billed 5 hours a day and costs $7,128 a month on Enterprise in AWS US East (Northern Virginia), before storage. Set your own hours in the calculator.
- Which region is cheapest for a Snowflake X-Large warehouse?
- On Enterprise, a X-Large costs least in Azure East US 2 (Virginia), Azure Central US (Iowa), Azure East US and 4 other regions, at $60.00 an hour, and most in AWS South America East 1 (São Paulo), at $100, of the 48 regions on AWS, Azure and Google Cloud. The gap comes from the price of a credit in each region and, on Gen2, the credits an hour on each cloud.
- Is a Snowflake X-Large the same as a Databricks X-Large SQL warehouse?
- Only in name. A Databricks X-Large serverless SQL warehouse uses 80 DBUs an hour, $56.00 at $0.70 a DBU in AWS US East (Northern Virginia), against $64.80 for the Snowflake X-Large. The machines and engines differ, so the same queries take a different time on each.
- Is there a Snowpark-optimized X-Large warehouse?
- Yes. A Snowpark-optimized X-Large, with up to 256 GB of memory a node, uses 24 credits an hour and 30 with up to 1 TB. It suits code with large memory needs, such as machine learning training.
- What is the next Snowflake warehouse size up or down from X-Large?
- One size down is Large, at 8 credits an hour on Gen1; one size up is 2X-Large, at 32. Each size up doubles the credits, so a query that finishes in half the time on the larger size costs the same.
Sources
Where each fact comes from
- 1Snowflake: pricing calculator
- 2Snowflake: Service Consumption Table (credits of each warehouse, credit, storage and transfer prices, serverless rates)
- 3Snowflake documentation: understanding compute cost (per-second billing, cloud services)
- 4Snowflake documentation: Gen2 standard warehouses
- 5Snowflake documentation: Snowpark-optimized warehouses
- 6Snowflake documentation: overview of warehouses (sizes, auto-suspend)
- 7Databricks: pricing on AWS (the price of a DBU for each kind of compute and plan)
- 8Databricks: SQL warehouse sizing, scaling and queuing