Hello Team, I've started exploring SigNoz, i wante...
# support
r
Hello Team, I've started exploring SigNoz, i wanted to connect to clickhouse DB, i am unable to connect(using signoz docker compose) . can anyone help me connecting to clickhouse db?
p
Hey @Raviteja Chavali! You can
exec
into the ClickHouse container and run
clickhouse-client
.
Copy code
docker exec -it clickhouse-setup_clickhouse_1 bash

root@d68a4a5c8d59:/# clickhouse-client

ClickHouse client version 21.12.3.32.armprestable.arm (altinity build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.12.3 revision 54452.

d68a4a5c8d59 :)
r
Hi @Prashant Shahi thanks for quick response, so my scenario here is, as Grafana supports clickhouse datasource, I want to connect my clickhouse from Grafana and compare with signoz. why grafana: we are already using it and wanted to see how signoz wins before we take a call.
p
That would be possible. However, it is not recommended since you would have the overhead of manually updating queries with schema changes across different SigNoz versions.
a
@Raviteja Chavali you might want to expose the ports of clickhouse at https://github.com/SigNoz/signoz/blob/main/deploy/docker/clickhouse-setup/docker-compose.yaml#L6 and the connect using any client
a
Copy code
@Ankit Nayan root@uls-tst01-gen1-7b64d94f9c-2zlr8:/# uname -a
Linux uls-tst01-gen1-7b64d94f9c-2zlr8 5.4.0-1025-gkeop #26~18.04.1-Ubuntu SMP Mon Oct 4 03:14:34 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
root@uls-tst01-gen1-7b64d94f9c-2zlr8:/#
r
@Ankit Nayan thanks, will check and get back to you.