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;BufferSize=8192;User=default;Password=Note: SeekTable connects to ClickHouse with binary protocol (like "clickhouse-client").
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.|
|BufferSize||TCP client receive buffer size. Default value is 1024 which may be to small if you need to load thousands of rows for your reports.|
|User||The username to connect with.|
|Password||The password to connect with.|