Helpful BigQuery Tutorials
August 25, 2026 · BQBrains Team
A prompt-to-Dataform walkthrough of the agent that went GA in April 2026, the SQLX it produced, what we changed before merging, and an honest list of its failure modes.
Read moreAugust 25, 2026 · BQBrains Team
Generate embeddings with ML.GENERATE_EMBEDDING, create an IVF or TreeAH vector index, write VECTOR_SEARCH queries, and finish with a minimal RAG query over a public dataset.
Read moreAugust 25, 2026 · BQBrains Team
Six copy-paste audit queries — top users, costliest statements, slot-hour hotspots, cache-hit rate, scheduled-query waste, missing partition filters — and the Looker Studio dashboard to keep them honest.
Read moreAugust 25, 2026 · BQBrains Team
Three nested queries rewritten with the |> operator, why EXTEND removes most throwaway CTEs, and the cases where classic SQL is still the right call.
Read moreAugust 25, 2026 · BQBrains Team
One workload priced three ways, how the autoscaler really bills, mixing on-demand and reservations by project, and the flat-rate habits to unlearn.
Read more