Get started
Yandex DataLens

Creating a ClickHouse connection

    Note

    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:

    1. Go to the connections page.

    2. Click Create connection.

    3. Select the ClickHouse connector.

      Warning

      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:

      • 77.88.39.88/29
      • 93.158.158.96/29
      • 93.158.156.80/29
      • 77.88.39.224/28
      • 37.9.126.112/28
      • 37.9.65.32/28

    4. 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.

    5. Click Connect. The connection appears in the list.

    You can check the host connection before creating it. To do this, click Check connection.