Connecting arcodash to ClickHouse

arcodash is a hosted BI tool with data checks built in: SQL dashboards, an AI query assistant, and scheduled checks that alert by email, Slack, Teams, webhook, or PagerDuty. It connects to ClickHouse over the HTTP(S) interface.

Gather your connection details

To connect to ClickHouse with HTTP(S) you need this information:

Parameter(s)	Description
`HOST` and `PORT`	Typically, the port is 8443 when using TLS or 8123 when not using TLS.
`DATABASE NAME`	Out of the box, there is a database named `default`, use the name of the database that you want to connect to.
`USERNAME` and `PASSWORD`	Out of the box, the username is `default`. Use the username appropriate for your use case.

The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console. Select a service and click Connect:

Choose HTTPS. Connection details are displayed in an example curl command.

ClickHouse Cloud HTTPS connection details

If you’re using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.arcodash needs the host, the HTTP port (8123, or 8443 for ClickHouse Cloud with HTTPS), the user, the password, and the database.

Create a read-only user

CREATE USER arcodash_ro IDENTIFIED BY 'change-me' SETTINGS readonly = 1;
GRANT SELECT ON analytics.* TO arcodash_ro;
GRANT SELECT ON system.columns TO arcodash_ro;

The schema browser reads system.columns.

Add the connector

In arcodash, choose Connect > ClickHouse and enter the host, port, user, password, and database. Turn on HTTPS for ClickHouse Cloud, then run the connection test.

Run a query and a check

SELECT dateDiff('second', max(loaded_at), now()) AS seconds_since_last_row
FROM analytics.events

Save the query as a monitor on seconds_since_last_row with the condition > 3600 to alert when a table stops receiving data.

Limitations

arcodash uses the HTTP interface only, not the native port 9000.
arcodash appends a FORMAT clause itself, so queries must not end with their own FORMAT.
Results are capped at 10,000 rows per query.
arcodash does not publish fixed outbound IP addresses, so the ClickHouse server must be reachable from the internet.

Data sources

Data visualization

Data ingestion

Data integrations

SQL-clients

Tools

Limitations