ClickHouse - Configure incoming connections
10 Views
25.02.2026 
ClickHouse
Objective
ClickHouse is an open-source, columnar analytical database system designed for real-time processing of massive data volumes, providing high performance, scalability, and low latency.
This guide explains how to configure your ClickHouse cluster to accept incoming connections via the OVHcloud Control Panel.
Requirements
- Access to the OVHcloud Control Panel.
- A Public Cloud project in your OVHcloud account.
- A ClickHouse cluster running on OVHcloud Public Cloud.
Instructions
Configuring the ClickHouse service
Once your ClickHouse service is up and running, you must define at least one user and one authorised IP (if not already provided during the order) to fully connect to the service (as producer or consumer).
The Dashboard tab automatically updates when your service is ready.
Setting up a user
Switch to the Users tab. An admin user named avnadmin is preconfigured during the service installation.
You can add more users by clicking the Add user button.
Enter a username, then click Create User.
Passwords need to be reset from the Users table.
Configuring authorised IPs
For security reasons, the default network configuration doesn't allow any incoming connections. You must therefore authorise the suitable IP addresses to access your ClickHouse cluster.
If you did not define the authorised IPs during the order, you can do it in the Configuration tab. At least one IP address must be authorised here before you can connect to your database.
Add the IP address of your computer by using the Current IP button.
You can remove IPs from the table afterward.
Your ClickHouse service is now fully accessible!
Optionally, you can configure access control lists (ACL) for granular permissions and create topics.
We want your feedback!
We would love to help answer questions and appreciate any feedback you may have.
If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.
Are you on Discord? Connect to our channel at https://discord.gg/ovhcloud and interact directly with the team that builds our Analytics service!
Join our community of users.
