ClickHouse
Overview
ClickHouse is an open-source column-oriented database for online analytical processing (OLAP).
It stores data by column and merges sorted parts in the background through its
MergeTree engine family, which makes aggregations and scans over billions of rows
extremely fast. ClickHouse organises objects as database → table
(a database is also the schema level), supports a rich SQL dialect with arrays, maps, tuples,
nested columns, and aggregate-state combinators, and runs anywhere from a single binary to a
large cluster as well as ClickHouse Cloud.
Driver
- Crate:
clickhouse - Version:
0.13
Connection fields
| Field | Description |
|---|---|
| Host | ClickHouse server hostname. |
| Port | HTTP interface port. Use 8443 for HTTPS / ClickHouse Cloud. |
| Database | Default database for unqualified queries. |
| User | ClickHouse user. |
| Password | User password. Stored in the macOS Keychain. |
| Options | Extra settings as key1=val1&key2=val2. |
All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. See SSH tunnels for details.
URI format
Instead of filling in each field individually, you can paste a connection URI into the Paste URI field. Arris parses the URI and populates all fields automatically.
clickhouse://user:password@host:8123/database
The path segment maps to the default database. Connection strings copied from ClickHouse Cloud
(HTTPS on port 8443) can be pasted directly — Arris extracts the host, port,
and database automatically.
SSL & TLS
Set SSL Mode to a TLS-enabling value (required or stricter) to connect over https. ClickHouse Cloud and
TLS-terminated servers expose the secure HTTP interface on port 8443, while a
local server serves plain http on 8123. TLS is provided by
rustls; no system OpenSSL is required.
Schema browser
Once connected, Arris reads system.databases, system.tables, and
system.columns to build the tree. Each ClickHouse database is a top-level node (a
database acts as the schema level), and its objects are grouped by category.
- Tables —
MergeTree-family and other table engines (dictionaries included) - Views — views
- Materialized Views — materialized views
Double-click any table or view to open it in a new tab with browse mode.
Supported SQL commands
| Command | Notes |
|---|---|
SELECT | Query data with WHERE filters, JOINs, aggregates, and window functions. |
INSERT | Insert single or multiple rows. |
UPDATE | Via ALTER TABLE … UPDATE mutations. |
DELETE | Via ALTER TABLE … DELETE mutations. |
CREATE / DROP | Create and drop tables, views, and other schema objects. |