HyperDX is really great. It is basically SQL on telemetry data in clickhouse.

Don’t use vector or otel-agent. Add a materialized view in clickhouse to transform data and swap HyperDX to load from your view (in the UI.)