ClickHouse
Overview
Umbrella's ClickHouse Cloud integration pulls daily cost data from the ClickHouse billing API and breaks it down by service and data warehouse - split into compute, storage, backup, and data transfer. This gives you granular visibility into data warehouse spend alongside the rest of your cloud costs.
The connection is read-only. Umbrella reads only the billing (usageCost) endpoint. It never accesses your databases, queries, or application data.
Prerequisites
Before you start, make sure you have:
- ClickHouse Cloud organization admin role - required to create organization-level API keys.
- Your Organization ID - a UUID found in Settings within the ClickHouse Cloud console.
- Network access - if you restrict API access by IP, add the addresses on the Allow list Umbrella Servers page. You can also set access to Anywhere.
What Umbrella reads
Umbrella ingests daily cost per service and data warehouse, broken into four categories:
- Compute
- Storage
- Backup
- Data transfer
Cost is gross (before committed-spend credits). ClickHouse uses a credit-based pricing model where 1 credit = 1 USD. No region-level breakdown is available in this release.
Create a ClickHouse Cloud API key
Umbrella connects through an organization-level API key with two roles.
Choose the longest expiryIngestion stops when the API key expires. Set the longest available expiry and track the renewal date.
- In ClickHouse Cloud, open your organization from the sidebar under Organization.
- Go to Settings > API keys.
- Click New API key.
- Assign both roles:
- Billing
- Service Reader
- Set the expiry to the longest available option.
- Set allowed access to Anywhere, or restrict to the addresses on the Allow list Umbrella Servers page.
- Click Create .
- Copy the Key ID and Key Secret. The secret is shown only once.
Connect in Umbrella
Open the ClickHouse Cloud onboarding wizard in Umbrella and enter the following:
| Field | What it is | Where to find it |
|---|---|---|
| Organization ID | UUID identifying your ClickHouse Cloud org | ClickHouse Cloud > Settings |
| Key ID | Alphanumeric identifier for the API key | Shown when you create the API key |
| Key Secret | Secret token for the API key | Shown once at key creation - copy it immediately |
What to expect
After you connect, Umbrella begins pulling cost data from the billing endpoint.
Cost appears in the Explorer broken down by ClickHouse Cloud service, with separate line items for compute, storage, backup, and data transfer.
Updated about 8 hours ago