JDBC Driver to Hydrolix

How to connect to Hydrolix using JDBC

As we leverage clickhouse for our SQL engine, you can connect to Hydrolix using the Clickhouse JDBC driver

There are some specific options you need to use in the connection when leveraging the JDBC driver for Hydrolix:

String url = "jdbc:clickhouse://$host.hydrolix.live:443/";
Properties properties = new Properties();
properties.setProperty("compress", "false");
properties.setProperty("web_context", "/query");
properties.setProperty("ssl", "true");

ClickHouseDataSource dataSource = new ClickHouseDataSource(url, properties);

As we have reverse proxy for the query endpoint you need to specify the web_context to use /query


Did this page help you?