What is BigQuery?
Answer
BigQuery is Google's fully managed, serverless data warehouse designed for ultra-fast SQL analytics on massive datasets. It can run SQL queries over petabytes of data in seconds to minutes without any infrastructure management. Key characteristics: Serverless: no clusters to provision or manage. Columnar storage: data stored in Capacitor format, highly compressed and optimized for analytical queries. Separation of storage and compute: scale independently. Pay per query ($5 per TB scanned) or flat-rate pricing. BigQuery ML: train ML models using SQL. BI Engine: in-memory analysis for sub-second queries. Streaming inserts: ingest real-time data. BigQuery integrates with Looker, Data Studio, and all major BI tools and is the flagship GCP analytics service.