Helpful BigQuery Tutorials
September 11, 2026 · BQBrains Team
Stop rebuilding 5 TB tables every hour. A hands-on guide to BigQuery's change-history TVFs, watermark-driven MERGE with two-sided partition pruning, late-arriving data, and Dataform incremental models.
Read moreSeptember 10, 2026 · BQBrains Team
Console clicks don't survive an audit. A practical guide to codifying BigQuery datasets, partitioned tables, authorized views, IAM, and slot reservations in Terraform — plus a plan/apply pipeline and the state traps that bite data teams.
Read moreSeptember 9, 2026 · BQBrains Team
When to reach for STRUCT, an ARRAY of STRUCT, the native JSON type, or a plain join key — with UNNEST patterns, JSON_VALUE vs. STRING(), and the scan-cost math behind each choice.
Read moreSeptember 9, 2026 · BQBrains Team
A practical walkthrough of the BigQuery Migration Service: running a migration assessment, translating Snowflake, Redshift, or Teradata SQL in batch and interactively, moving the data, and proving the results match with the Data Validation Tool.
Read moreSeptember 9, 2026 · BQBrains Team
A hands-on time-series tutorial: one-line forecasts with AI.FORECAST and the TimesFM foundation model, trained ARIMA_PLUS models with holiday and regressor support, hierarchical forecasts, and how to evaluate and schedule the result.
Read more