Hey Team, I am planning to fetch spans from the da...
# support
m
Hey Team, I am planning to fetch spans from the database and show them on the SigNoz UI. Can someone help me the format of span needed to store in the database, so the Signoz UI can fetch it easily?
s
How are you running SigNoz? When you run our docker or helm deployment there would be signoz-otel-collector which is responsible for writing the trace (along with metric and log) data in required format. Are you trying to write spans to db through other means?
m
Hey @Srikanth Chekuri I'm writing data to the ClickHouse using a job which is receiving spans from opentelemetry collector. So I'm storing spans individually. Can you share the format in which I can write the spans to the ClickHouse DB?
Like in Jaegar there is a Jaegar Query Search Engine which get the spans of the same Traceid and join them together. But in signoz how things work?
s
You should instead send data to SigNoz collector
m
That's a lot of work and then the setup will be Signoz dependent (I just want to make platform independent). Currently I'm using Opentelemetry Collector which sends the spans and those spans are stored in the database separately. If someone wants to use the Signoz UI only then is there any way?
s
and those spans are stored in the database separately.
What database are you storing them?
m
Clickhouse
s
We are not a UI project. You will have a very hard time just using the SigNoz UI because there is always work that is going on. The schema evolves over time. SigNoz otel collector is just another distribution of OpenTelemetry collector that is maintained by us with our own schema and certain changes. It's virtually not possible to use just UI.
l
Hi @Mohammad Arshad I think I have run into the same problem. I do not want to be SigNoz dependent and would like store all the data in my database and connect some UI only. Do you have any news on this, please?
m
Hey Yes, I am using grafana v10 for it. Grafana needs some specific fields which you can check here https://github.com/grafana/grafana/blob/main/packages/grafana-data/src/types/trace.ts Doc: https://grafana.com/docs/grafana/latest/explore/trace-integration/ Picture for the traces at my local now Please do let me know if you need more help around it,
l
Thank you very much! I will take a look at it and maybe follow with questions later🙏
Hi after a long time 😅 I have a question, please @Mohammad Arshad. Are you also viewing Events and References in grafana? I just can't get to how to write the query properly for it to show them