via DBeaver
The Hydrolix platform supports queries using various client applications. This page describes the settings needed to connect a DBeaver client to a Hydrolix cluster.
Prerequisites
Before beginning this guide, check to make sure that you've enabled access to your cluster from your current IP.
Connect DBeaver to the Cluster
First, create a connection to your cluster. Open General and right click Connections. From the context menu, select Create, then Connection.
![newconnection.png 784](https://files.readme.io/e3fe250-newconnection.png)
Select Clickhouse as your Database. Click Next.
![clickhouse-option.png 879](https://files.readme.io/993b434-clickhouse-option.png)
DBeaver uses a JDBC connection to connect to your Hydrolix Cluster. Enter the following details:
- Host: your Hydrolix hostname, e.g.
myhost.hydrolix.live
- Port:
8088
Click on the Driver Properties tab and edit the following settings:
- compression:
false
- path:
/query
- ssl:
true
![compress-property.png set compress to false](https://files.readme.io/daaddeb-compress-property.png)
![path-property.png set path to /query](https://files.readme.io/047f671-path-property.png)
![ssl-property.png set SSL to true](https://files.readme.io/37f8ce5-ssl-property.png)
Finally, test your connection by clicking Test Connection on the bottom left. This should issue a successful connection message like the one below.
To finalize the client connection, click OK. You can now query your Hydrolix cluster from DBeaver.
Updated 8 months ago