ClickHouse to FinOps FOCUS format
The FinOps FOCUS format is a unifying format for cloud cost data that standardizes billing information across multiple providers, making it easier to analyze, compare, and report on cloud spending across your providers. The standardized output can be imported into any tool that supports the FOCUS standard.
ClickHouse Instructions
To retrieve the CSV of your cost data for transformation:
- Navigate to your ClickHouse Cloud console
- Select your organization then click "Billing" from the left-hand navigation
- Download the CSV for the desired billing period
Drag and drop to upload or
ClickHouse Costs to FinOps FOCUS
The following table shows how ClickHouse fields are mapped to FOCUS fields:
| FOCUS Field | ClickHouse Field |
|---|---|
| Availability Zone | Region |
| Billed Cost | Total (CHC) |
| Billing Period End | Date |
| Billing Period Start | Date |
| Charge Period End | Date |
| Charge Period Start | Date |
| Invoice Issuer | "ClickHouse" |
| Provider | "ClickHouse" |
| Publisher | "ClickHouse" |
| Region Name | Region |
| Resource ID | Service ID |
| Resource Name | Entity Name |
| Resource Type | Entity Type |
Cloud Provider Cost Report
FinOps FOCUS Format
Please double-check your responses and reach out to [email protected] for suggestions.
Files are processed temporarily and deleted immediately after conversion. No billing data is stored. Learn more about our security. By uploading a file, you agree to our processing of your cost data according to our Privacy Policy and Terms of Service. Subprocessors: Cloudflare.