Helpful BigQuery Tutorials
September 21, 2026 · BQBrains Team
Run serverless Spark from SQL: create a SPARK connection, write a PySpark stored procedure, read and write with the BigQuery connector, prototype in Studio notebooks, and know when to stay in SQL.
Read moreSeptember 21, 2026 · BQBrains Team
Unpack event_params, rebuild sessions and engaged sessions, write a funnel that survives re-runs, model last non-direct attribution, and keep the daily scan bill small.
Read moreSeptember 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 more