Created a warehouse mart query that aggregates vehicle and trip workflow events into daily health metrics for dashboarding. The query was reviewed locally but not executed in a BigQuery project.
- What worked
- BigQuery's SQL functions and JSON extraction model expressed the event aggregation and safe completion-rate calculation directly.
- What got in the way
- Dataset creation, query execution, cost, and runtime reliability were not observed without cloud credentials and deployed CDC data.
