Raviteja Chavali

    Raviteja Chavali

    5 months ago
    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?
    Prashant Shahi

    Prashant Shahi

    5 months ago
    Hey @Raviteja Chavali! You can
    exec
    into the ClickHouse container and run
    clickhouse-client
    .
    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 :)
    Raviteja Chavali

    Raviteja Chavali

    5 months ago
    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.
    Prashant Shahi

    Prashant Shahi

    5 months ago
    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.
    Ankit Nayan

    Ankit Nayan

    5 months ago
    @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

    alan

    5 months ago
    @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:/#
    Raviteja Chavali

    Raviteja Chavali

    5 months ago
    @Ankit Nayan thanks, will check and get back to you.