Connecting to ClickHouse®
Can I connect to individual ClickHouse® hosts?
Yes. You can connect to ClickHouse® cluster hosts:
-
Using the HTTPS interface
:- Via an encrypted SSL connection on port 8443.
- Without encryption through port 8123.
-
Using the command-line client
:- Via an encrypted SSL connection on port 9440.
- Without encryption through port 9000.
SSH connections are not supported.
Why cannot I connect to a host from the internet?
Most likely, no public access is enabled for the cluster, so you can only connect to it from a VM in Yandex Cloud. You can only request public access when creating a new host in your cluster.
How do I connect to a non-public host in Yandex Cloud?
Connect to a host from a VM in Yandex Cloud hosted in the same cloud network, or add a new cluster host with public access and connect to a non-public host through it.
Can I connect to a public cluster without SSL?
No. You can only connect to public hosts using an SSL connection. For more information, see the documentation.
Can I connect to cluster hosts via SSH or get superuser permissions on hosts?
You cannot connect to hosts via SSH, nor can you get superuser permissions. This is done for the sake of security and user cluster fault tolerance because direct changes inside a host can render it completely inoperable.
ClickHouse® is a registered trademark of ClickHouse, Inc