Helpful BigQuery Tutorials
September 14, 2026 · BQBrains Team
Load and clean GEOGRAPHY data, understand BigQuery's spherical geometry, write spatial joins that actually prune, use S2 and H3 grid keys for clustering, and render results without exporting the warehouse.
Read moreSeptember 14, 2026 · BQBrains Team
When to use a SQL UDF, a JavaScript UDF, a remote function backed by Cloud Run, or a Vertex AI-backed function — with working examples, IAM and batching details, and the row-count mistake that blows up the bill.
Read moreSeptember 14, 2026 · BQBrains Team
A hands-on guide to BigQuery Omni: federated connections to AWS and Azure, partition-filtered external tables, cross-cloud joins that do not blow up your egress bill, reservations, quotas, and the staged-migration pattern that actually works.
Read moreSeptember 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 more