https://signoz.io logo
#general
Title
# general
a

Ashish

11/22/2023, 10:27 AM
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?
a

Ashish

11/24/2023, 10:18 AM
@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
n

nitya-signoz

11/24/2023, 10:24 AM
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 ?
a

Ashish

11/24/2023, 1:04 PM
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.
n

nitya-signoz

11/24/2023, 1:06 PM
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 ?
a

Ashish

11/24/2023, 1:26 PM
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
n

nitya-signoz

11/24/2023, 1:29 PM
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.
a

Ashish

11/24/2023, 1:49 PM
Oh, will check it out. Thanks!