What is BigQuery Omni?
BigQuery Omni extends BigQuery to data in AWS S3 and Azure Blob Storage. Data is analyzed where it resides, without moving it to Google Cloud. The same BigQuery SQL syntax and governance works across all three major cloud providers.
Core Features
- Multi-Cloud Query: Same BigQuery SQL syntax for GCP, AWS and Azure data
- Data Residency: Data does not leave its original cloud
- Cross-Cloud Joins: Connect data from different clouds in one query
- Unified Governance: BigQuery IAM and policies apply to all data sources
- BigLake Integration: Fine-grained access control also on external data
Typical Use Cases
Multi-Cloud Organizations
Organizations with workloads in multiple clouds analyze all data with one tool. No separate analytics platforms per cloud required.
M&A Integration
After acquisitions, data from the acquired company can be analyzed directly without elaborate migration. Analytics starts immediately, migration can happen later.
Data Sovereignty
Regulated industries keep data in specific regions or clouds. BigQuery Omni analyzes data on-site without crossing compliance boundaries.
Benefits
- One analytics platform for multi-cloud environments
- No ETL pipelines for cross-cloud analytics
- Retain existing cloud contracts and data residency
- Unified skill set for analysts
Integration with innFactory
As a Google Cloud Partner, innFactory supports you with BigQuery Omni: multi-cloud architecture, cross-cloud query optimization, governance design and cost management for distributed data landscapes.
Available Tiers & Options
BigQuery Omni
- No data movement
- Unified SQL interface
- Cross-cloud joins
- Additional costs
- Latency for large joins
Typical Use Cases
Technical Specifications
Frequently Asked Questions
What is BigQuery Omni?
BigQuery Omni runs BigQuery analytics on data in AWS S3 and Azure Blob Storage without copying the data to Google Cloud. Data remains in its original cloud.
How does BigQuery Omni work technically?
BigQuery Omni starts compute resources in AWS or Azure that directly access data in the respective cloud storage. Results are returned to BigQuery.
Can data from different clouds be joined?
Yes, BigQuery Omni enables cross-cloud joins between GCP, AWS and Azure data. Smaller result sets are transferred for the join.
Which regions are supported?
BigQuery Omni is available in selected AWS regions (us-east-1, eu-west-1) and Azure regions (eastus2). Availability is continuously expanding.
