Skip to the page
Tecyfy

BigQuery pricing in Turin

In Turin (europe-west12), BigQuery charges $8.06 for each TiB a query scans on demand, or $0.052, $0.078 and $0.13 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 · europe-west12

Queries, on demand and on slots

On demand
$8.06
A TiB scanned, the first a month free
Standard
$0.052
A slot-hour, pay as you go
Enterprise
$0.078
A slot-hour, pay as you go
Enterprise Plus
$0.13
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.052NoneNone$37.96
Enterprise$0.078$0.0624$0.0468$56.94
Enterprise Plus$0.13$0.104$0.078$94.90

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.0516$0.0258
Batch load
$0
On the shared slot pool
Storage Write API
$0.03225
A GiB, the first 2 TiB a month free
Streaming inserts
$0.0129
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 Turin?
On demand, $8.06 for each TiB a query scans in Turin (europe-west12), after the first TiB a month, which is free. Scanning 20 TiB a month costs $153.
How much does a BigQuery slot cost in Turin?
Pay as you go, a slot-hour costs $0.052 on Standard, $0.078 on Enterprise and $0.13 on Enterprise Plus. On Enterprise, a slot committed for 1 year costs $0.0624 an hour (20 percent off) and for 3 years $0.0468 (40 percent off).
Is on-demand or capacity pricing cheaper in Turin?
For 100 slots busy 6 hours a day on 22 days, Standard costs $686 a month, the same as scanning 86.13 TiB on demand. Queries that scan less cost less on demand; more, and slots cost less.
How much does BigQuery storage cost in Turin?
Logical storage costs $0.023 a GiB a month, and $0.016 for data not modified for 90 days. Physical storage costs $0.0516 and $0.0258, 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 Turin?
The Storage Write API costs $0.03225 a GiB after the first 2 TiB a month, and legacy streaming inserts $0.0129 a 200 MiB, counting each row as at least 1 KB. Batch loading is free.
Can I buy BigQuery spend-based commitments in Turin?
No. Google's price list gives no spend-based commitment for Turin (europe-west12). Slot commitments, on Enterprise and Enterprise Plus, still take 20 percent off for 1 year and 40 percent for 3.
Is Turin one of the cheapest BigQuery locations?
No. A TiB on demand costs $8.06 in Turin (europe-west12), 29 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.