Cross-region BigQuery queries between Sydney and Melbourne: Latency and Egress math
1. The Core Problem: Data Gravity vs. Centralized Analytics Historically, Google Cloud Platform (GCP) enforced strict geographical boundaries on data processing within BigQuery. If a company stored a dataset in the Sydney region (australia-southeast1) and another dataset in the Melbourne region (australia-southeast2), joining these tables in a single SQL statement was impossible. Data gravity dictated…
