Creating a ClickHouse connection
DataLens specifics for ClickHouse connections:
- ClickHouse connections only run over HTTP interface.
- All the data requests are executed with the join_use_nulls flag enabled.
To create a ClickHouse connection:
Go to the connections page.
Click Create connection.
Select the ClickHouse connector.
When connecting to an external data source (which is not a Yandex.Cloud resource), grant access to the source for the following ranges of DataLens IP addresses:
Specify the connection parameters:
Connection name. Specify a name for the connection. You can set any name.
Hostname or IP. Specify the path to the ClickHouse host.
Port. Specify the ClickHouse connection port.
Username. Enter the username for the ClickHouse connection.
The user should have one of the following values set for the parameter readonly:
0— All queries are allowed.
2— Queries to read data and edit settings are allowed.
Password. Enter the password for the user.
Click Connect. The connection appears in the list.
You can check the host connection before creating it. To do this, click Check connection.