Google BigQuery
Serverless, multicloud data warehouse to power your data-driven innovations.
First 1 TB of queries
Free per month
Storage
First 10 GB free per month
Architecture
Serverless, decoupled compute & storage
Data analysis
Built-in ML, BI, and geospatial analysis
About Google BigQuery
BigQuery is a serverless, highly scalable, and cost-effective multicloud data warehouse designed for business agility. Its architecture separates compute and storage, allowing users to query massive datasets in seconds without managing infrastructure. It supports standard SQL and offers built-in features like BigQuery ML for creating and executing machine learning models, geospatial analysis, and BigQuery Omni for analyzing data across different clouds like AWS and Azure. It integrates deeply with the Google Cloud ecosystem, including tools like Looker, Dataproc, and Cloud Dataflow, as well as numerous third-party applications for data ingestion, transformation, and visualization. The platform is designed for large-scale data processing and is suitable for real-time analytics, reporting, and building powerful BI solutions.
Core Features
Query Engine
Dremel engine for running SQL queries over massive datasets in seconds.
Bigquery Ml
Create and execute machine learning models in BigQuery using standard SQL queries.
Bigquery Omni
A multicloud analytics solution that lets you analyze data across Google Cloud, AWS, and Azure.
Separation Of Compute And Storage
Scales storage and compute resources independently and automatically, ensuring performance and cost-efficiency.
Real-Time Analytics
High-speed data ingestion and immediate availability for querying.
Data Management
Data Ingestion
Supports batch loading and real-time streaming from various sources.
Storage
Managed columnar storage optimized for analytical queries, with automatic backups and replication.
Data Types
Support for standard SQL data types, plus complex types like ARRAY, STRUCT, and GEOGRAPHY.
Security & Access Control
Iam Integration
Granular control over access to projects, datasets, tables, and views through Google Cloud IAM.
Data Encryption
All data is automatically encrypted at rest and in transit.
Vpc Service Controls
Provides data exfiltration protection by creating security perimeters around projects.