Prerequisites
- A ClickHouse server with the HTTP interface enabled (typically port 8443 for TLS or 8123 for plaintext).
- A user with read access to the target database.
Required fields
| Field | Description | Example |
|---|---|---|
| Name | A display name for this datasource. | Graphics Press warehouse |
| URL | The full HTTP(S) URL of your ClickHouse instance. | https://your-instance.clickhouse.cloud:8443 |
| Username | The ClickHouse user. | default |
| Password | The user’s password. |
Optional fields
| Field | Description | Example |
|---|---|---|
| Database | The default database to query. If omitted, ClickHouse uses its configured default (usually default). | default |
Steps
- Open Settings → Datasources → New.
- Enter a name and select ClickHouse as the type.
- Fill in the URL, username, and password.
- Optionally specify a default database.
- Click Test connection to verify.
- Click Create.
Troubleshooting
- Connection refused — Confirm the URL includes the correct port (8443 for ClickHouse Cloud, 8123 for self-hosted without TLS).
- Authentication failed — Verify the username and password. The default ClickHouse user is
default.