Connect Aiven for ClickHouse® to external databases via JDBC#

You can use ClickHouse JDBC driver to connect external sources to your Aiven for ClickHouse database.

You will need Aiven for ClickHouse® service, accessible by HTTPS. The connection values you need can be found in Aiven Console > your service’s page > Overview > Connection information > ClickHouse HTTPS & JDBC.

Variable

Description

CLICKHOUSE_HTTPS_HOST

HTTPS service host of your ClickHouse service.

CLICKHOUSE_HTTPS_PORT

HTTPS service port of your ClickHouse service.

CLICKHOUSE_USER

Username to access ClickHouse service.

CLICKHOUSE_PASSWORD

Password to access ClickHouse service.

Connection string#

Replace CLICKHOUSE_HTTPS_HOST and CLICKHOUSE_HTTPS_PORT with your connection values:

jdbc:ch://CLICKHOUSE_HTTPS_HOST:CLICKHOUSE_HTTPS_PORT?ssl=true&sslmode=STRICT

You’ll also need to provide user name and password to establish the connection. For example, if you use Java:

Connection connection = dataSource.getConnection("CLICKHOUSE_USER", "CLICKHOUSE_PASSWORD");