This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Yandex ClickHouse connection for pivot table reports

ClickHouse can be used as a data source with SQL-compatible database connector.

Connection String example:

Host=hostName;Port=9000;Database=default;Compress=True;Compressor=lz4;User=default;Password=
Note: SeekTable connects to ClickHouse with binary protocol (like "clickhouse-client").
Host Specifies the host name of the machine on which the ClickHouse is running.
Do not use "localhost" or LAN server name; use only public IP address or server's domain name.
Database The ClickHouse database to connect to.
User The username to connect with.
Password The password to connect with.
Compress if true compression is used for packets sent between SeekTable and ClickHouse server.