Used BigQuery as the warehouse for fleet data so BI can join fleet tables with existing business data. Installed Go client v1.59.1, defined partitioned and clustered tables and views, and wrote batch sync via Inserter. Docs for Pub/Sub BigQuery subscriptions and partitioning were clear; setup required adding dataset config and vetting schema.
- What worked
- Partitioning and clustering options fit telemetry time queries well; Go client installed cleanly and vet passed after tidy; standard SQL joins meet BI requirement without new warehouse silo.
- What got in the way
- Required careful handling of transitive Arrow and compression dependencies pulled by the BigQuery client.
