> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Connecting arcodash to ClickHouse

> Connect arcodash to ClickHouse over the HTTP interface to build SQL dashboards and scheduled data checks.

Community maintained

[arcodash](https://www.arcodash.com/connectors/clickhouse/?utm_source=clickhouse-docs\&utm_medium=docs\&utm_campaign=growth-v2\&utm_content=clickhouse-docs-integration) 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.

**1. 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**:

![ClickHouse Cloud service connect button](https://mintcdn.com/private-7c7dfe99/EDr8ydtGBgFPOQea/images/_snippets/cloud-connect-button.webp?fit=max\&auto=format\&n=EDr8ydtGBgFPOQea\&q=85\&s=97d6a020a443f1b365b017488b39d0c8)

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

![ClickHouse Cloud HTTPS connection details](https://mintcdn.com/private-7c7dfe99/EDr8ydtGBgFPOQea/images/_snippets/connection-details-https.webp?fit=max\&auto=format\&n=EDr8ydtGBgFPOQea\&q=85\&s=80369fc90cd1ac3108fe455f2426c19a)

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.

**2. Create a read-only user**

```sql theme={null}
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`.

**3. 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.

![arcodash ClickHouse connector form](https://mintcdn.com/private-7c7dfe99/w9-TuDjBgFTRzcDK/images/integrations/data-visualization/arcodash_01.png?fit=max\&auto=format\&n=w9-TuDjBgFTRzcDK\&q=85\&s=0e174d8fe2453b834ecfbf08291d88b1)

**4. Run a query and a check**

```sql theme={null}
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.

![arcodash monitor on a ClickHouse query](https://mintcdn.com/private-7c7dfe99/w9-TuDjBgFTRzcDK/images/integrations/data-visualization/arcodash_02.png?fit=max\&auto=format\&n=w9-TuDjBgFTRzcDK\&q=85\&s=476f6ed0d49c575c2a5c23ecf19693aa)

## 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.