Helpful BigQuery Tutorials
September 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 moreSeptember 9, 2026 · BQBrains Team
Turn scheduled-query sprawl into a tested, Git-backed pipeline: sources, incremental MERGE models with partition filters, assertions, environments, and CI — all inside BigQuery.
Read moreSeptember 9, 2026 · BQBrains Team
A practical walkthrough of exposing BigQuery to an LLM agent over the Model Context Protocol: running MCP Toolbox for Databases, defining read-only tools over authorized views, and putting hard cost and permission guardrails around every generated query.
Read more