Google Cloud has recently announced the preview of a global queries feature for BigQuery. The new option lets developers run SQL queries across data stored in different geographic regions without firs

InfoQ is a leading online platform for software developers, architects, and technical leaders, providing news, articles, presentations, and interviews on a wide range of topics, including agile practices, DevOps, microservices, and emerging technologies. With a focus on quality content and expert insights, InfoQ helps professionals stay informed about the latest trends, best practices, and industry developments. Developers can learn from real-world experiences, gain  knowledge, and connect with peers in the global software community through InfoQ's diverse and engaging content.

InfoQ

Google Cloud has announced a preview of global queries for BigQuery, enabling SQL queries across data stored in multiple geographic regions without ETL pipelines or data movement. BigQuery automatically identifies query parts that must run in different regions, executes them locally, transfers only the results to the primary query location, and combines everything. Developers must explicitly opt in by configuring `enable_global_queries_execution` and `enable_global_queries_data_access` flags. The feature comes with higher latency than single-region queries, additional costs (compute per subquery, cross-region data transfer, and 8-hour storage of copied data), and compliance considerations since data physically crosses regional boundaries. AWS Redshift and Athena offer similar cross-region querying but without the same automatic distributed execution coordination.

Google BigQuery Previews Cross-Region SQL Queries for Distributed Data