Connect DataDatabases
ClickHouse
You connect ClickHouse from the DataSquares connection wizard. Official HTTP interface — host, port 8123 and database credentials.
-
In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.
-
Pick ClickHouse on that page (search or browse by category).
-
Fill in the connection details below, then test the connection and save.
Connection details
Section titled “Connection details”| Field | What to enter |
|---|---|
| Host | The hostname or IP address of your ClickHouse server. |
| Port | Prefilled with 8123 (the ClickHouse default) — change it if your server listens elsewhere. |
| Database | The database to connect to. |
| Username / Password | Credentials for a user with read access to the tables you want to analyze. |
| TLS | On by default: Use SSL/TLS encryption connects encrypted and verifies the server certificate. Tick Trust self-signed certificate for a private CA; turn TLS off only for a server that has none. |
Grant the connection user read-only access — DataSquares only ever reads from your source.
Related
Section titled “Related”- Connector catalog — everything DataSquares connects to.
- Quickstart — from connection to shared dashboard.