GCP BigQuery — Data Warehouse Guide

BigQuery provides serverless data warehouse for analyzing massive datasets.

GCP BigQuery — Data Warehouse Guide
Querying Data
SQL Examples
FAQ

Querying Data

# Run query
bq query --use_legacy_sql=false \
  'SELECT COUNT(*) FROM `project.dataset.table`'

# Load data
bq load dataset.table gs://bucket/data.csv

# Export results
bq extract dataset.table gs://bucket/export.json

SQL Examples

SELECT
  user_id,
  COUNT(*) as events,
  MAX(timestamp) as last_event
FROM dataset.events
WHERE timestamp >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7 DAY)
GROUP BY user_id
ORDER BY events DESC
LIMIT 100

FAQ

Q: What's BigQuery pricing? A: Per query—$6.25 per TB scanned (first 1TB free monthly).

Q: Is BigQuery suitable for OLTP? A: No, optimized for OLAP (analytics). Use Cloud SQL for transactional data.