StackSpendDocs

ClickHouse Cloud

Connect your ClickHouse Cloud organization to track compute, storage, data transfer, and ClickPipes costs in StackSpend.

ClickHouse Cloud logo

ClickHouse Cloud

Usage Cost API — Organization billing read key required

The ClickHouse Cloud provider connects StackSpend to your organization via the ClickHouse Cloud Usage Cost API. StackSpend backfills up to 90 days of usage on first sync, then updates daily as new charges are finalized.

What StackSpend tracks

  • Compute costs per warehouse and service
  • Storage and backup charges
  • Data transfer costs
  • ClickPipes usage
  • Costs denominated in ClickHouse Credits (1 CHC = 1 USD)
  • 90 days of historical data, updated daily
Note.The ClickHouse Cloud Usage Cost API does not support date ranges longer than 31 days. StackSpend automatically chunks requests into 31-day windows to retrieve the full 90-day history.

Prerequisites

  • A ClickHouse Cloud organization account
  • An API key with Organization billing read access

Setup

1

Create an API key

In the ClickHouse Cloud console, go to Organization → API Keys → Generate API key. Set the role to Organization billing read.

Copy the Key ID and Key Secret. The secret is shown only once — store it somewhere safe before closing the dialog.

2

Get your Organization ID

This step is only needed if your API key can access multiple organizations. In the ClickHouse Cloud console, go to Organization → Settings and copy the Organization ID.

If your key is scoped to a single organization, you can leave this field blank in StackSpend.

3

Add to StackSpend

In StackSpend, go to Providers → ClickHouse Cloud. Enter your API Key ID, API Key Secret, and optionally your Organization ID. Click Save.

Unlocked usage records.Recent usage data from ClickHouse Cloud may be in an “unlocked” state, meaning it is pending finalization and can change. StackSpend re-syncs recent periods on each update cycle to capture any corrections.

Data summary

AttributeValue
Data latencyDaily
Historical data90 days
Setup time5 min
StackSpend Docs