Helpful BigQuery Tutorials
September 16, 2026 · BQBrains Team
Commitments, reservations, and assignments explained, then a practical design: behaviour-based slot pools, baselines vs. autoscaling, idle-slot sharing, a deliberate on-demand escape hatch, and the INFORMATION_SCHEMA queries that prove it worked.
Read moreSeptember 15, 2026 · BQBrains Team
The BigQuery-specific half of dbt: insert_overwrite vs. merge, copy_partitions, require_partition_filter, maximum_bytes_billed, materialized views, unit tests, and a CI pipeline that builds only what changed.
Read moreSeptember 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 more