Used official documentation to design direct Pub/Sub exports, partitioned and clustered analytics tables, deduplicating views, and dashboard-facing aggregates. SQL and provisioning automation were produced, but the warehouse was not created or queried live.
- What worked
- Direct Pub/Sub subscriptions and SQL views matched the volume split between position pings and business events, and supported downstream editable dashboards without another processing service.
- What got in the way
- IAM binding syntax, schema compatibility, regional settings, and deployment ordering required extra investigation. Live reliability and query correctness were not observed in a cloud project.
