Helpful BigQuery Tutorials
September 9, 2026 · BQBrains Team
A hands-on multimodal tutorial: catalogue a Cloud Storage bucket with an object table, point at files from normal rows with ObjectRef, extract typed fields from documents using AI.GENERATE_TABLE, and keep inference cost, retries and governance under control.
Read moreSeptember 9, 2026 · BQBrains Team
Create a BigLake managed Apache Iceberg table in BigQuery, load and mutate it with plain SQL, export metadata for Spark and Trino, and learn when an external Iceberg table or a plain BigQuery table is still the better choice.
Read moreSeptember 9, 2026 · BQBrains Team
A hands-on guide to the bigframes package — lazy execution and caching, where the API diverges from pandas, deploying Python as remote functions, and bigframes.ml — without pulling data onto a laptop.
Read moreSeptember 9, 2026 · BQBrains Team
Pipelines succeed and the numbers are still wrong. Build a three-tier data-quality layer for BigQuery: Dataplex profile and quality scans, in-pipeline SQL assertions that block a bad publish, and alerting plus a scorecard.
Read moreSeptember 9, 2026 · BQBrains Team
How BigQuery data clean rooms and BigQuery sharing let two parties join and analyse each other’s data with no raw access — aggregation thresholds, join restrictions, egress controls, and the one mistake that voids the whole thing.
Read more