All data in BigQuery is in US regions; object stores in AWS and Azure (US) also hold data. You need daily queries across all data with minimal data movement. Which option do you choose?

The correct answer is to use BigQuery Omni with BigLake tables to query files in Azure and AWS. BigQuery Omni allows you to analyze data residing in other clouds (AWS S3 and Azure Data Lake Storage) directly from BigQuery, without moving the data. BigLake tables provide a unified access layer over these external data sources, enabling fine-grained access control and performance optimizations. This approach minimizes data movement, which is a key requirement, and allows for daily queries across all data. Loading data into BigQuery using Data Transfer Service or Dataflow, or moving files to Cloud Storage with gsutil rsync, all involve significant data movement, which goes against the requirement of minimal data movement. These methods would incur egress costs from AWS/Azure and ingress costs into Google Cloud, and add latency for daily queries.