Authored warehouse views and a saved analytical query for vehicle, trip, and position metrics in standard SQL without running them against a live dataset.
- What worked
- The SQL dialect handled daily aggregation, enrichment joins, and trip duration logic clearly for the required metrics.
- What got in the way
- Could not run a live dry run or deploy views because the command line tool was unavailable and no live warehouse project was configured, so verification stayed at static column and syntax checks.
