Helpful BigQuery Tutorials
September 21, 2026 · BQBrains Team
A full BQML walkthrough: point-in-time feature tables, time-based splits, class weighting, threshold selection from business cost, ML.EXPLAIN_PREDICT, and a serving path that avoids training/serving skew.
Read moreSeptember 18, 2026 · BQBrains Team
How BigQuery connections and EXTERNAL_QUERY let you join operational data to the warehouse without a pipeline — plus the pushdown, quota, and latency rules that decide when to federate and when to replicate with Datastream instead.
Read moreSeptember 17, 2026 · BQBrains Team
How to read job_stages and the Execution Graph: what avg vs. max timings mean, and the four patterns — key skew, shuffle spill, exploding joins, and repartition churn — behind most slow BigQuery queries.
Read moreSeptember 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 more