ClickHouse connection

To access your data in ClickHouse, create a connection asset for it.

ClickHouse is an open-source column-oriented database management system (DBMS).

Supported versions

ClickHouse 25.9

Create a connection to ClickHouse

To create the connection asset, you need these connection details:

  • Hostname or IP address
  • Port number
  • Database name

Credentials

  • User name and Password

Certificates

  • Port is SSL-enabled: Enable this option if the port you have chosen is configured to accept SSL connections.

If the Port is SSL-enabled option is enabled, fill in the following fields:

  • SSL certificate: Enter the SSL certificate of the host to be trusted
  • Hostname in SSL certificate: The hostname in SubjectAlternativeName or Common Name (CN) part of the SSL certificate
  • Validate the SSL certificate: Enable this option to validate that the SSL certificate returned by the host is trusted.

ClickHouse setup

Quick start

Running SQL statements

To ensure that your SQL statements run correctly, refer to the ClickHouse SQL Reference for the correct syntax.

Learn more