Skip to the page
Tecyfy
Daily Bytes app

Snowflake 5X-Large warehouse cost

A 5X-Large Gen1 warehouse uses 256 credits an hour, so on Enterprise in AWS US East (Northern Virginia) it costs $768 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.

Cost a 5X-Large warehouseQuestions

Credits an hour

5X-Large at a glance

Gen1 standard
256
Every cloud
Gen2, AWS
None
Not sold in this size
Gen2, Azure
None
Not sold in this size
Gen2, Google Cloud
None
Not sold in this size
Snowpark, 256 GB
384

An hour on each edition

In AWS US East (Northern Virginia), for 1 cluster, billed by the second. Gen2 credits are AWS's.

WarehouseCreditsStandardEnterpriseBusiness Critical
Gen1 standard256$512$768$1,024
Snowpark-optimized, 256 GB384$768$1,152$1,536

In each region

An hour on Enterprise, cheapest first, on Gen2 where the region sells it. Each region has its own page.

Every size

Work it out

Questions

How many credits does a Snowflake 5X-Large warehouse use?
A 5X-Large uses 256 credits an hour, as a Gen1 standard warehouse. Snowflake sells no Gen2 warehouse this large, so a 5X-Large is Gen1. Each cluster of a multi-cluster warehouse uses the same again.
How much does a Snowflake 5X-Large warehouse cost an hour?
In AWS US East (Northern Virginia), a 5X-Large Gen1 warehouse costs $512 an hour on Standard, $768 on Enterprise and $1,024 on Business Critical, for 256 credits an hour. Each region sets its own price for a credit, so the hour costs more or less there.
What does a 5X-Large warehouse cost for 10 minutes?
$128 on Enterprise in AWS US East (Northern Virginia): Snowflake bills by the second, so 10 minutes uses a sixth of the 256 credits an hour, 42.67 credits. Each start bills at least 60 seconds, $12.80, and the warehouse keeps billing until it suspends, 10 idle minutes by default.
What does a Snowflake 5X-Large warehouse cost a month?
Running queries 4 hours a day over 6 starts, 22 days a month, with the default auto-suspend, a 5X-Large Gen1 warehouse is billed 5 hours a day and costs $84,480 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 5X-Large warehouse?
On Enterprise, a 5X-Large costs least in AWS US East (Northern Virginia), AWS US East 2 (Ohio), AWS US West (Oregon) and 10 other regions, at $768 an hour, and most in Google Cloud Middle East Central 2 (Dammam), at $1,254, 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 there a Databricks SQL warehouse as large as a Snowflake 5X-Large?
Not by name. Databricks' serverless SQL warehouses stop at 4X-Large, while Snowflake sells Gen1 warehouses up to 6X-Large. A larger Databricks workload adds clusters to a warehouse instead.
What is the next Snowflake warehouse size up or down from 5X-Large?
One size down is 4X-Large, at 128 credits an hour on Gen1; one size up is 6X-Large, at 512. 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

  1. 1Snowflake: pricing calculator
  2. 2Snowflake: Service Consumption Table (credits of each warehouse, credit, storage and transfer prices, serverless rates)
  3. 3Snowflake documentation: understanding compute cost (per-second billing, cloud services)
  4. 4Snowflake documentation: Gen2 standard warehouses
  5. 5Snowflake documentation: Snowpark-optimized warehouses
  6. 6Snowflake documentation: overview of warehouses (sizes, auto-suspend)
  7. 7Databricks: pricing on AWS (the price of a DBU for each kind of compute and plan)
  8. 8Databricks: SQL warehouse sizing, scaling and queuing