Connecting to ClickHouse

Connect your ClickHouse Cloud account to CloudZero to bring your ClickHouse cost and usage data into a unified view of all your cloud and SaaS spend. CloudZero organizes your ClickHouse costs, along with your other costs, into categories (called Dimensions) that matter most to your business. For example: business unit, team, product, feature, environment, customer, or virtually anything else. Once connected and organized, you can quickly answer questions about your spend that matter to your stakeholders.

This guide covers creating a ClickHouse Cloud API key and configuring the connection in CloudZero. CloudZero ingests daily organization-level cost data along with service and ClickPipes metadata. The connection is read-only.

What you need

• CloudZero user with data configuration permissions
• A ClickHouse Cloud account with permissions to create API keys. The Developer role is sufficient.

Step 1: Copy your Organization ID

1. Sign in to ClickHouse Cloud.
2. In the bottom-left of the console, open your Organization and select Organization Details.
3. Copy the Organization ID.

Step 2: Create an API key in ClickHouse

For full details, see ClickHouse's API key documentation.

1. In the ClickHouse Cloud console, select API Keys from the left menu.
2. Select New API Key.
3. Enter a descriptive name (for example, "CloudZero Integration").
4. Assign the Developer role (read-only access is all CloudZero needs). An existing Admin key also works.
5. Set an expiration that matches your security policy.
6. Select Generate API Key.
7. Copy the Key ID and Key Secret immediately. ClickHouse displays the Key Secret only once.

Step 3: Configure the connection in CloudZero

1. In CloudZero, go to Settings > Cloud Connections.

2. Select Create Connection + and select the ClickHouse tile.

3. Enter the connection details:

   Field	Value
   Connection Name	A name for this connection in CloudZero
   Organization ID	The Organization ID from Step 1
   Key ID	The Key ID from Step 2
   Key Secret	The Key Secret from Step 2

4. Select Create Connection.

What to expect

After you connect, CloudZero begins ingesting your ClickHouse cost data. Your ClickHouse costs appear in Explorer and Analytics within 24 hours. Once data is available, you can view costs broken down by service, data warehouse, ClickPipe, region, cloud provider, and cost metric (compute, storage, backup, data transfer, and others).

From there, your ClickHouse costs work like any other cost data in CloudZero. For example, you can organize them by team or product using Dimensions, track trends in Dashboards, set Budgets, or ask questions in the AI Hub.