Designed the warehouse landing as a partitioned and clustered events table fed by subscription, with stable ID join keys and a reusable daily aggregation for BI. No live dataset was created or queried during the task.
- What worked
- Table design supported time-range pruning and vehicle-scoped joins while keeping dashboard queries simple for analysts.
- What got in the way
- Live service behavior was not exercised, so delivery latency and ordering were not observed.
