Getting started with Managed Service for ClickHouse

    1. To create a DB cluster, all you need is a folder available to you in Yandex.Cloud. If you already have one, open the page of that folder in the management console. If there is no folder yet, create one:

      1. In the management console, click Create folder.

      2. Enter the folder name.

        The name may contain lowercase Latin letters, numbers, and hyphens. The first character must be a letter. The last character can't be a hyphen. The name length must be from 3 to 63 characters.

      3. Click Create folder.

    2. You can connect to DB clusters from both inside and outside of the Cloud:

      1. To connect to a DB cluster from inside the Cloud, create a VM in the same network as the DB cluster (based on Linux or [Windows](../compute/quickstart/quick-create-windows md))
      2. To enable connection to a cluster over the internet, request external IP addresses for hosts when creating the cluster.
    3. In the management console, select the folder where you want to create a DB cluster.

    4. Click Create resource and select Cluster ClickHouse.

    5. Set the cluster parameters and click Create cluster. The process is described in detail in the section Creating a ClickHouse cluster.

    6. When the cluster is ready to operate, its status on the Managed Service for ClickHouse dashboard will change to RUNNING.

    7. To connect to the database server, an SSL certificate is required. Download it:

      $ wget "https://storage.yandexcloud.net/mdb/CA.pem"
      
    8. Send a request specifying the path to the received SSL certificate, database attributes, and the request text in urlencoded format:

      $ curl --cacert <path to the SSL certificate> \
           -H "X-ClickHouse-User: <DB user name>" \
           -H "X-ClickHouse-Key: <DB user password>" \
           'https://<host address>:8443/?database=<DB name>&query=SELECT%20now ()'