Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex Managed Service for ClickHouse®
  • Getting started
    • All guides
      • Pre-configuration
      • FQDNs of hosts
      • Connecting from applications
      • Code examples
      • Updating a TLS certificate chain
  • Access management
  • Inspections and recommendations
  • Pricing policy
  • Yandex Monitoring metrics
  • Audit Trails events
  • Public materials
  • Release notes

In this article:

  • Configuring security groups
  • Obtaining an SSL certificate
  • Getting intermediate SSL certificates for connections over ODBC
  • What's next
  • Useful links
  1. Step-by-step guides
  2. Connection
  3. Pre-configuration

Pre-configuring a ClickHouse® cluster connection

Written by
Yandex Cloud
Updated at November 12, 2026
View in Markdown
  • Configuring security groups
  • Obtaining an SSL certificate
  • Getting intermediate SSL certificates for connections over ODBC
  • What's next
  • Useful links

You can connect to Managed Service for ClickHouse® cluster hosts:

  • Via the internet, if you configured public access for the host. These hosts can only be accessed over SSL.

  • From Yandex Cloud virtual machines located in the same cloud network. For hosts without public access, SSL is not required to connect to them from these virtual machines.

You can connect to a cluster either with encryption (on ports 9440 for clickhouse-client and 8443 for the HTTP interface) or without it (on ports 9000 and 8123, respectively).

Configuring security groupsConfiguring security groups

To connect to a cluster, security groups must include rules allowing traffic from certain ports, IP addresses, or from other security groups.

Rule settings depend on the chosen connection method:

Over the internet
From a Yandex Cloud VM

Configure all the cluster security groups to allow incoming traffic on ports 8443 and 9440 from any IP address. To do this, create the following rules for incoming traffic:

  • Port range: 8443 and 9440.
  • Protocol: TCP.
  • Source: Address range.
  • IPv4 CIDR: 0.0.0.0/0.

Create a separate rule for each port.

Warning

For a more secure cluster, specify only trusted IP addresses or subnets in the IPv4 CIDR field.

  1. Configure all the cluster security groups to allow incoming traffic from your VM's security group on ports 8123, 8443, 9000, and 9440. To do this, create the following rules for incoming traffic in these security groups:

    • Port range: 8123 (or any of the other ports listed).
    • Protocol: TCP.
    • Source: Security group.
    • Security group: If your cluster and VM share the same security group, select Current (Self). Otherwise, specify the VM security group.

    Create a separate rule for each port.

  2. Configure the VM security group to allow VM connections and traffic between the VM and cluster hosts.

    For example, you can set the following rules for your VM:

    • For incoming traffic:

      • Port range: 22.
      • Protocol: TCP.
      • Source: Address range.
      • IPv4 CIDR: 0.0.0.0/0.

      This rule allows inbound VM connections over SSH.

    • For outgoing traffic:

      • Port range: 0-65535.
      • Protocol: Any (Any).
      • Destination name: Address range.
      • IPv4 CIDR: 0.0.0.0/0.

      This rule permits all outbound traffic, allowing you to install any necessary certificates and tools on your VM.

Note

You can specify more granular security group rules, such as allowing traffic only in specific subnets.

Make sure to configure the security groups correctly for all subnets where the cluster hosts will reside. With incomplete or incorrect security group settings, you may lose access to the cluster.

For more information about security groups, see Network and database clusters.

Obtaining an SSL certificateObtaining an SSL certificate

To use an encrypted connection, get an SSL certificate:

Linux (Bash)
macOS (Zsh)
Windows (PowerShell)
sudo mkdir --parents /usr/local/share/ca-certificates/Yandex/ && \
sudo wget "https://storage.yandexcloud.net/cloud-certs/RootCA.pem" \
     --output-document /usr/local/share/ca-certificates/Yandex/RootCA.crt && \
sudo chmod 655 \
     /usr/local/share/ca-certificates/Yandex/RootCA.crt && \
sudo update-ca-certificates

The certificate will be saved to the /usr/local/share/ca-certificates/Yandex/RootCA.crt file.

sudo mkdir -p /usr/local/share/ca-certificates/Yandex/ && \
sudo wget "https://storage.yandexcloud.net/cloud-certs/RootCA.pem" \
     --output-document /usr/local/share/ca-certificates/Yandex/RootCA.crt && \
sudo chmod 655 \
     /usr/local/share/ca-certificates/Yandex/RootCA.crt && \
security import /usr/local/share/ca-certificates/Yandex/RootCA.crt -k ~/Library/Keychains/login.keychain

The certificate will be saved to the /usr/local/share/ca-certificates/Yandex/RootCA.crt file.

  1. Download and import the certificate:

    mkdir -Force $HOME\.yandex; `
    curl.exe https://storage.yandexcloud.net/cloud-certs/RootCA.pem `
      --output $HOME\.yandex\RootCA.crt; `
    Import-Certificate `
      -FilePath $HOME\.yandex\RootCA.crt `
      -CertStoreLocation cert:\CurrentUser\Root
    

    Your corporate security policies and antivirus software may block the certificate download. For more information, see FAQ.

  2. Confirm that that you agree to install the certificate in the Trusted Root Certification Authorities store.

The certificate will be saved to the $HOME\.yandex\RootCA.crt file.

To use graphical IDEs, save a certificate to a local folder and specify the path to it in the connection settings.

Getting intermediate SSL certificates for connections over ODBCGetting intermediate SSL certificates for connections over ODBC

Cluster connections over ODBC might require installing intermediate SSL certificates. To install them, run this command:

Linux (Bash)
Windows (PowerShell)
sudo mkdir --parents /usr/local/share/ca-certificates/Yandex/ && \
sudo wget "https://storage.yandexcloud.net/cloud-certs/RootCA.pem" \
     --output-document /usr/local/share/ca-certificates/Yandex/RootCA.crt && \
sudo wget "https://storage.yandexcloud.net/cloud-certs/IntermediateCA.pem" \
     --output-document /usr/local/share/ca-certificates/Yandex/IntermediateCA.crt && \
sudo wget "https://storage.yandexcloud.net/cloud-certs/IntermediateCA-2033.pem" \
     --output-document /usr/local/share/ca-certificates/Yandex/IntermediateCA-2033.crt && \
sudo chmod 655 \
     /usr/local/share/ca-certificates/Yandex/RootCA.crt \
     /usr/local/share/ca-certificates/Yandex/IntermediateCA.crt \
     /usr/local/share/ca-certificates/Yandex/IntermediateCA-2033.crt && \
sudo update-ca-certificates

The certificates will be saved to the following files:

  • /usr/local/share/ca-certificates/Yandex/RootCA.crt
  • /usr/local/share/ca-certificates/Yandex/IntermediateCA.crt
  • /usr/local/share/ca-certificates/Yandex/IntermediateCA-2033.crt
mkdir -Force $HOME\.yandex; `
curl.exe https://storage.yandexcloud.net/cloud-certs/RootCA.pem `
  --output $HOME\.yandex\RootCA.crt; `
curl.exe https://storage.yandexcloud.net/cloud-certs/IntermediateCA.pem `
  --output $HOME\.yandex\IntermediateCA.crt; `
curl.exe https://storage.yandexcloud.net/cloud-certs/IntermediateCA-2033.pem `
  --output $HOME\.yandex\IntermediateCA-2033.crt; `
Import-Certificate `
  -FilePath $HOME\.yandex\RootCA.crt `
  -CertStoreLocation cert:\CurrentUser\CA; `
Import-Certificate `
  -FilePath $HOME\.yandex\IntermediateCA.crt `
  -CertStoreLocation cert:\CurrentUser\CA; `
Import-Certificate `
  -FilePath $HOME\.yandex\IntermediateCA-2033.crt `
  -CertStoreLocation cert:\CurrentUser\CA

Your corporate security policies and antivirus software may block certificate download. For more information, see FAQ.

The certificates will be saved to the following files:

  • $HOME\.yandex\RootCA.crt
  • $HOME\.yandex\IntermediateCA.crt
  • $HOME\.yandex\IntermediateCA-2033.crt

What's nextWhat's next

  • Get the FQDN of the host you want to connect to.
  • Connect to the cluster using a browser, graphical IDE, or CLI.
  • Integrate the cluster connection into your application code.

Useful linksUseful links

  • ClickHouse® connection FAQ

ClickHouse® is a registered trademark of ClickHouse, Inc.

Was the article helpful?

Previous
Deleting a cluster
Next
FQDNs of hosts
© 2026 Direct Cursus Technology L.L.C.