v.23.6New Feature

Clickhouse-client Supports Connection String Usage

Official CH changelog text
Clickhouse-client can now be called with a connection string instead of "--host", "--port", "--user" etc. #50689 (Alexey Gerasimchuck).
The clickhouse-client tool now supports using a connection string instead of separate connection parameters like --host, --port, and --user.

Why it matters

This feature simplifies and streamlines how users connect to ClickHouse by allowing them to specify all connection details in a single connection string, improving user experience and reducing command complexity.

How to use it

Instead of using multiple flags such as --host, --port, and --user, users can now pass a single connection string to clickhouse-client. For example:

clickhouse-client 'clickhouse://user:password@host:port/database'

Related resources

PreviousNext