ClickHouse Cloud
Vantage connects to your ClickHouse Cloud account via a read-only API key with Developer permissions to ingest ClickHouse usage, costs, and discounts from ClickHouse’s Organization usageCost API. Vantage displays ClickHouse Cloud costs and associated usage metrics.
The Clickhouse Organizations usageCost API only supports ClickHouse Cloud and Bring Your Own Cloud (BYOC).
You can view usage data for ClickHouse Cloud consumption. Usage is measured by the following subcategories:
- Compute
- Storage
- Data transfer (egress over the internet and cross-region)
- ClickPipes
Usage is measured in ClickHouse Cloud Credits (CHCs), which is a metering unit used by ClickHouse.
You can learn more about CHCs through ClickHouse Billing documentation.
You can integrate multiple ClickHouse Cloud integrations by providing read-only tokens for multiple organizations.
Connect Your ClickHouse Cloud Account
Prerequisites
Create a free Vantage account, then follow the steps below to integrate ClickHouse Cloud costs.
Vantage cannot perform writes to your ClickHouse Cloud organization. Vantage is only able to see metadata associated with your usage.
Create the Connection
The below instructions for creating an API key are based on the ClickHouse documentation.
In the ClickHouse Cloud console, navigate to the Settings menu. Then, select API keys.
Click + New API key.
Expand to view example image
Add the following key details:
- For API key name, enter vantage.
- For Organization Permissions, select Developer. (You can read more about roles and permissions in the ClickHouse documentation.)
- For Expires, select an expiration date. If the key expires, you will need to supply Vantage with a new ClickHouse Cloud API key.
Expand to view example image
Click Generate API Key.
noteIf you have any IP restrictions set, ensure you allow the following IP addresses for Vantage:
54.87.66.45
3.95.43.133
54.162.3.72
44.199.143.63
3.218.103.23
Copy the newly generated Key ID and Key Secret.
Expand to view example image
From the top navigation in Vantage, click Settings.
On the left navigation, select Integrations and select ClickHouse Cloud.
The ClickHouse Cloud integrations page is displayed. Ensure you are on the Connect tab.
At the bottom of the page, click Add API Key and paste your newly generated API key and secret.
For Organization ID, add the ClickHouse Cloud Organization ID that was assigned to your organization during creation. To find this ID:
- From the Settings navigation menu, under Organization, select your organization and click Organization details.
- Copy the value displayed next to Organization ID and paste this in the Vantage integration form.
Expand to view example image
Click Connect Account.
Costs will be ingested and processed as soon as you add the integration. It usually takes less than 15 minutes to ingest ClickHouse Cloud costs. As soon as they are processed, they will be available on your All Resources Cost Report. If you decide to remove your ClickHouse Cloud integration from Vantage, all costs associated with your ClickHouse Cloud API key will be removed from the Vantage console.
Next Steps: Manage Workspace Access
Once your costs are imported, select which workspaces this integration is associated with. See the Workspaces documentation for information.
Data Refresh
See the provider data refresh documentation for information on when data for each provider refreshes in Vantage.
Active Resources
ClickHouse Cloud services are synced as active resources and available in resource reports.
ClickHouse Cloud Reporting Dimensions
On ClickHouse Cloud Cost Reports, you can filter across several dimensions:
- Organization (i.e., billing account)
- Service (e.g., ClickHouse Cloud)
- Category (e.g., datawarehouse or service)
- Subcategory (e.g., specific usage category, like
interRegionTier1DataTransferCHC
orpublicDataTransferCHC
) - Resource (specific ID for a given ClickHouse cluster)
- Tags (Virtual Tags created in Vantage)
- Charge Type (e.g., usage)
You can also view credits or discounts for ClickHouse Cloud costs in Cost Reports.
- At the top of any ClickHouse Cloud Cost Report, click Settings.
- Then, toggle on/off Credits and/or Discounts.