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.

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

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