What Is BigQuery?
By Karthick Selvam · Published · Updated
BigQuery is Google Cloud's serverless, fully managed data warehouse.
How it works
You load or stream data into tables and query with SQL. Google manages infrastructure and scaling, with storage separated from compute.
Pricing models
On-demand pricing based on data scanned, or capacity-based pricing. Check current pricing.
Performance tips
Partition and cluster tables, select only needed columns, and avoid SELECT * on large tables.
Extras
BigQuery ML for in-database machine learning, and integrations with BI tools.
Frequently asked questions
Does BigQuery need indexes?
Not in the traditional sense; partitioning and clustering do most of that job.
Related programmes
Turn this into a team capability
Our corporate programmes cover topics like this hands-on, mapped to your stack.
Cloud guides
AWS vs Azure vs Google Cloud: Which Should Your Team Learn?
The three largest public clouds share core concepts but differ in strengths and ecosystem.
Serverless vs Containers
Two popular ways to run applications in the cloud, with different trade-offs.
AWS Certifications Explained
An overview of AWS certification levels and how to choose.