Designed warehouse datasets, stub raw tables, and mart views so replicated operational tables and streamed telemetry could be joined by analysts and used as dashboard sources. Work stayed in SQL and infrastructure config; nothing was executed against a live warehouse.
- What worked
- SQL views were a clear way to keep metric definitions out of application code and to give dashboards a flat, typed layer instead of raw change-capture tables.
- What got in the way
- Granting analysts access through views that read a raw dataset needed extra authorized-view and access-list handling, including ignoring access drift so identity bindings would not fight the view grants. Type names in JSON schemas also had to be checked against warehouse types.
