GCP BigQuery

Overview

Google BigQuery is a serverless, petabyte-scale data warehouse. It runs SQL queries across massive datasets in seconds, with no infrastructure to manage. Pay only for queries run and data stored.

Instructions

Core Concepts

• Dataset — a container for tables, scoped to a project and region
• Table — structured data with a schema (native, external, or view)
• Partitioned Table — split data by date/integer for query performance
• Clustered Table — sort data within partitions for further optimization
• Streaming Insert — real-time data ingestion
• BigQuery ML — train and predict with ML models using SQL

Datasets and Tables