Hi, I am trying to query the data from clickhouse db but I noticed that data field is unreadable in some tables. I can't see any collation info either when I use the describe table query. Can someone tell me if it's possible to read this data?

The usage table is for internal purpose. logs: https://signoz.io/docs/userguide/logs_clickhouse_queries/ traces: https://signoz.io/docs/userguide/writing-clickhouse-traces-query/ metrics: https://signoz.io/docs/userguide/write-a-metrics-clickhouse-query/

@nitya-signoz Is there any other way I can export that data? So many metrics like Infrastructure usage, latency, etc are being monitored but I couldn't find it in the database, so I am guessing it's in one of these tables that I am unable to read

Usage table is for your signoz usage. For you all your application/infra metrics being ingested are stored in

signoz_metrics.distributed_samples_v2

Please follow this guide https://signoz.io/docs/userguide/write-a-metrics-clickhouse-query/ you will get an idea. Also what is the use case that you are trying to solve ?

Ok, thanks a lot. I get it now. I am trying to export metrics and traces data to see if it would be possible to perform data analysis outside of Signoz. Signoz provides a lot of insights with good dashboards but having access to this data would enable us to analyse info which may not be readily available in signoz.

Can you list down the usecases that you are not able to solve right now with signoz ? Also where do you plan to analyse the data ?

We have not implemented Signoz yet, I am just doing some initial research on the tool. Right now, we are looking at control over the data as a positive, as it would allow us to set up any scripts or find trends, if required in future

Got it in that case you might not even need to look clickhouse just check https://github.com/open-telemetry/opentelemetry-collector-contrib/tree/main/exporter . https://github.com/open-telemetry/opentelemetry-collector-contrib/tree/main/processor this will allow you to export your data anywhere and process it as well.

Oh, will check it out. Thanks!