BQ Cross Region

BigQuery datasets live in regions.

Example regions:

• US multi-region

• EU multi-region

• asia-northeast1

? Rules

• Queries must run in dataset region

• Cross-region joins incur data transfer

• Egress charges apply

? Latency & Compliance

For global org:

• EU customer data → EU region

• US data → US region

Avoid mixing.

? Cross-Region Strategy

Option 1: Replicate Aggregates Only

Instead of copying 1PB raw:

• Keep raw in primary region

• Replicate daily aggregates

• BI runs regionally

Option 2: Dual Ingestion

Ingest regionally
Aggregate locally
Federate results at reporting layer

? Disaster Recovery

Use:

• Cross-region dataset replication

• Backup snapshots

Be aware:

• Replication increases storage cost

• But cheaper than downtime