Skip to content
ENExplore Calculators

Snowflake Credit Cost Calculator

Work out snowflake credit cost instantly with clear inputs, formula shown and shareable results.

About Snowflake Credit Cost Calculator

Credit consumption doubles with each warehouse size step, and billing is per second with a sixty-second minimum per resume. The auto-suspend timer matters more than it looks: a warehouse that resumes twenty times a day with a five-minute timer burns credits idling for over an hour and a half, which on a Large warehouse is thirteen wasted credits daily.

Formula

Credit consumption

credits per hour doubles per size step from 1 at X-Small; daily = credits per hour x active hours + idle credits before suspend; cost = credits x price

Worked example

With the default values below, Snowflake Credit Cost Calculator returns Monthly credit cost of $3,896.32. Change any input above and every figure here is recalculated in your browser.

Inputs used

Warehouse sizeone of X-Small (1 credit/hour), Small (2), Medium (4), Large (8), X-Large (16)
Large (8)
Active hours per dayaccepts 0.01–24 h
5 h
Price per creditminimum 0
3
Auto-suspend timerminimum 1 s
60 s

Results

Monthly credit cost
$3,896.32
Credits consumed per day
42.67
Credits burned waiting to auto-suspend
2.67
Credits per hour for this size
8

Step by step

  1. 1Values used
  2. 2Credit consumption
  3. 3Monthly credit cost= 3,896.32
  4. 4Credits consumed per day= 42.67
  5. 5Credits burned waiting to auto-suspend= 2.67
  6. 6Credits per hour for this size= 8

Assumptions and limits

  • The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
  • In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
  • Figures are rounded for display to 2 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Frequently Asked Questions

Is a larger warehouse more expensive for the same query?

Not necessarily. It costs twice per hour but may finish in less than half the time, making it cheaper as well as faster. Test rather than assuming.

What auto-suspend timer is best?

Sixty seconds for interactive workloads, since the warehouse cache is lost on suspend but idle credits are expensive. For batch-only warehouses, suspend immediately.

Snowflake Credit Cost Calculator | Calcrivo