How much does BigQuery cost per TiB in London?

On demand, $7.81 for each TiB a query scans in London (europe-west2), after the first TiB a month, which is free. Scanning 20 TiB a month costs $148.

How much does a BigQuery slot cost in London?

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 London?

For 100 slots busy 6 hours a day on 22 days, Standard costs $686 a month, the same as scanning 88.86 TiB on demand. Queries that scan less cost less on demand; more, and slots cost less.

How much does BigQuery storage cost in London?

Logical storage costs $0.023 a GiB a month, and $0.016 for data not modified for 90 days. Physical storage costs $0.052 and $0.026, 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 London?

The Storage Write API costs $0.03125 a GiB after the first 2 TiB a month, and legacy streaming inserts $0.0126 a 200 MiB, counting each row as at least 1 KB. Batch loading is free.

Can I buy BigQuery spend-based commitments in London?

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 London one of the cheapest BigQuery locations?

No. A TiB on demand costs $7.81 in London (europe-west2), 25 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.

BigQuery pricing in London

In London (europe-west2), BigQuery charges $7.81 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.

Cost BigQuery here Questions

BigQuery · europe-west2

Queries, on demand and on slots

On demand: $7.81; 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.

Edition	Pay as you go	1 year	3 years	A slot a month
Standard	$0.052	None	None	$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 by	Active, a GiB	Long-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.052	$0.026

Batch load: $0; On the shared slot pool
Storage Write API: $0.03125; A GiB, the first 2 TiB a month free
Streaming inserts: $0.0126; 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 London?: On demand, $7.81 for each TiB a query scans in London (europe-west2), after the first TiB a month, which is free. Scanning 20 TiB a month costs $148.
How much does a BigQuery slot cost in London?: 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 London?: For 100 slots busy 6 hours a day on 22 days, Standard costs $686 a month, the same as scanning 88.86 TiB on demand. Queries that scan less cost less on demand; more, and slots cost less.
How much does BigQuery storage cost in London?: Logical storage costs $0.023 a GiB a month, and $0.016 for data not modified for 90 days. Physical storage costs $0.052 and $0.026, 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 London?: The Storage Write API costs $0.03125 a GiB after the first 2 TiB a month, and legacy streaming inserts $0.0126 a 200 MiB, counting each row as at least 1 KB. Batch loading is free.
Can I buy BigQuery spend-based commitments in London?: 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 London one of the cheapest BigQuery locations?: No. A TiB on demand costs $7.81 in London (europe-west2), 25 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.

Sources