Hey
Can I send custom data to the clickhouse insta...
# generalu
Utibeabasi Umanah
11/28/2024, 7:56 PMHey
Can I send custom data to the clickhouse instance used by my self hosted signoz?
Is it advisable? And can I query the data in signoz
s
Srikanth Chekuri
11/29/2024, 7:19 AMPlease explain in more detail, what custom data are you talking about?
u
Utibeabasi Umanah
11/29/2024, 7:21 AMi want to write data to a table within the clickhouyse instance
i want to store some metrics and i dont want them to be subjected to the retention period
Utibeabasi Umanah
11/29/2024, 7:24 AMand i want to create dashboards for this metric within signoz
Utibeabasi Umanah
11/29/2024, 7:26 AMim open to suggestion on alternative ways to go about this as well
s
Srikanth Chekuri
11/30/2024, 2:18 AMYou can write to separate tables and write ClickHouse queries
Srikanth Chekuri
11/30/2024, 2:18 AMBut with that, you can't use signoz-otel-coll as writing or query-service query builder
u
Utibeabasi Umanah
11/30/2024, 3:03 AMcan you explain the last part more?
s
Srikanth Chekuri
11/30/2024, 4:05 AMIf you have to write to a table that SigNoz manages, it will be subject to TTL changes, if you write to separate tables, then you are on your own to make sure to write to separate tables, and writing queries to read them.
u
Utibeabasi Umanah
11/30/2024, 4:14 AMok but the separate tables wont be affected by signoz retention period right?
s
Srikanth Chekuri
11/30/2024, 4:15 AMcorrect
u
Utibeabasi Umanah
11/30/2024, 4:15 AMalright thanks
7 Views