I’m a big fan of Clickhouse for observability with their otlp ingest and HTTP SQL endpoint (and an agent pointed at the latter). Also keeping an eye on smithclay.github.io/duckdb-otlp/ for the same sort of stack with DuckDB.
DuckDB OpenTelemetry Extension
duckdb-otlp: query OpenTelemetry traces, logs, and metrics with DuckDB.
smithclay.github.io