Skip to the page
Tecyfy

BigQuery pricing in Salt Lake City

In Salt Lake City (us-west3), BigQuery charges $8.44 for each TiB a query scans on demand, or $0.05, $0.075 and $0.125 a slot-hour on Standard, Enterprise and Enterprise Plus. Logical storage costs $0.023 a GiB a month, and $0.016 once it is long-term.

BigQuery · us-west3

Queries, on demand and on slots

On demand
$8.44
A TiB scanned, the first a month free
Standard
$0.05
A slot-hour, pay as you go
Enterprise
$0.075
A slot-hour, pay as you go
Enterprise Plus
$0.125
A slot-hour, pay as you go

A slot-hour under each commitment

Slot commitments are for Enterprise and Enterprise Plus, from 50 slots in steps of 50, billed every hour of the term. A slot all month is 730 slot-hours.

EditionPay as you go1 year3 yearsA slot a month
Standard$0.05NoneNone$36.50
Enterprise$0.075$0.06$0.045$54.75
Enterprise Plus$0.125$0.10$0.075$91.25

Storage and loading

Billed byActive, a GiBLong-term, a GiB
LogicalUncompressed bytes; time travel and fail-safe included$0.023$0.016
PhysicalCompressed bytes, plus time travel and fail-safe at the active rate$0.05$0.025
Batch load
$0
On the shared slot pool
Storage Write API
$0.03375
A GiB, the first 2 TiB a month free
Streaming inserts
$0.0136
A 200 MiB, each row at least 1 KB

Every location

A TiB on demand, cheapest first.

Work it out

Questions

How much does BigQuery cost per TiB in Salt Lake City?
On demand, $8.44 for each TiB a query scans in Salt Lake City (us-west3), after the first TiB a month, which is free. Scanning 20 TiB a month costs $160.
How much does a BigQuery slot cost in Salt Lake City?
Pay as you go, a slot-hour costs $0.05 on Standard, $0.075 on Enterprise and $0.125 on Enterprise Plus. On Enterprise, a slot committed for 1 year costs $0.06 an hour (20 percent off) and for 3 years $0.045 (40 percent off).
Is on-demand or capacity pricing cheaper in Salt Lake City?
For 100 slots busy 6 hours a day on 22 days, Standard costs $660 a month, the same as scanning 79.22 TiB on demand. Queries that scan less cost less on demand; more, and slots cost less.
How much does BigQuery storage cost in Salt Lake City?
Logical storage costs $0.023 a GiB a month, and $0.016 for data not modified for 90 days. Physical storage costs $0.05 and $0.025, for the compressed bytes plus those kept for time travel and fail-safe. The first 10 GiB a month are free.
How much does BigQuery streaming cost in Salt Lake City?
The Storage Write API costs $0.03375 a GiB after the first 2 TiB a month, and legacy streaming inserts $0.0136 a 200 MiB, counting each row as at least 1 KB. Batch loading is free.
Can I buy BigQuery spend-based commitments in Salt Lake City?
Yes. A spend-based commitment of a dollar amount an hour takes 10 percent off slot-hours for 1 year and 20 percent for 3, in every edition. Slot commitments, on Enterprise and Enterprise Plus, take off 20 percent and 40 percent.
Is Salt Lake City one of the cheapest BigQuery locations?
No. A TiB on demand costs $8.44 in Salt Lake City (us-west3), 35 percent more than the $6.25 of the cheapest locations, such as the US multi-region, the EU multi-region, Alabama (us-east7) and 7 more. A dataset's location is set when it is made, so choose it before loading data.