Beginner
Date Bucketing in GoogleSQL
Use DATE_TRUNC, EXTRACT, and calendar-safe filters for weekly and monthly reporting.
analyticsproduction
GoogleSQL Tutorials
Practical lessons for writing safer, faster, and easier-to-review BigQuery queries.
Intermediate
Window Functions for Analysts
Rank rows, compute running totals, and compare current rows to prior periods.
Practical
Safer BigQuery Cost Patterns
Reduce scanned bytes with partitions, selected columns, and bounded date filters.
Intermediate
Working with Arrays
Use UNNEST and ARRAY_AGG for nested BigQuery records without losing row meaning.
Practical
JSON in GoogleSQL
Extract typed fields from JSON columns and keep parsing logic reviewable.
Team
Query Review Checklist
A repeatable checklist for validating generated SQL before execution.