Hello, I am using the Signoz collector in a Docker standalone setup. On the frontend, I can see the trace, metric, and log data, but there are no records in the ClickHouse database. What could be the reason for this, and how can I resolve it? I need to query ClickHouse directly to build dashboards.

Which database are you looking at? It can't be possible you see data on UI but not in DB

The ClickHouse database, where the Signoz collector sends its data, doesn’t show any records in the tables no matter how much I try querying them

Please give the name of the database, table and the query you tried rather than a vague statement without any specific details. It helps reduce back-and-forth.

Sure, of course! If you'd like, you can check it yourself using AnyDesk. The scenario is that I have an API that, when called, returns a set of fields as a response. My goal is to query based on one of the fields in the response. Is such a thing even possible? If it is, which tables should I look at? Currently, I’m checking the following tables: •

signoz_traces.signoz_spans

, which is empty. •

signoz_metrics.time_series_v2

, which doesn’t contain the response details.

My goal is to query based on one of the fields in the response.

Are these fields present as part of span attributes?