ClickHouse Cloud: Clickhouse Usage Cost Get

Get a ClickHouse Cloud organization’s daily usage by service for a date range of up to 31 days, with a total.

Tool ID: clickhouse_usage_cost_get

Run this action

Use the TypeScript SDK for one call. Use ctx.tools.execute(...) inside a Play for durable calls, scheduled calls, or CSV processing.

import { Deepline } from 'deepline';

const deepline = await Deepline.connect();
const result = await deepline.tools.execute(
  'clickhouse_usage_cost_get',
  {
    "organizationId": "123e4567-e89b-42d3-a456-426614174000",
    "from_date": "2026-01-15",
    "to_date": "2026-01-15"
  },
);

console.log(result.toolResponse.raw);

CLI

deepline tools execute clickhouse_usage_cost_get --input '{
  "organizationId": "123e4567-e89b-42d3-a456-426614174000",
  "from_date": "2026-01-15",
  "to_date": "2026-01-15"
}' --json

Example response

The static output schema lacks the details for a reliable example. Use deepline describe clickhouse_usage_cost_get --json for the complete live contract.

Input reference

Returns a grand total and a list of daily, per-entity organization usage cost records for the organization in the queried time period (maximum 31 days). All days in both the request and the response are evaluated based on the UTC timezone.

Name	Type	Required	Default	Details
`payload.organizationId`	`string`	Yes	—	ID of the requested organization. Format: `uuid`.
`payload.from_date`	`string`	Yes	—	Start date for the report, e.g. 2024-12-19. Format: `date`.
`payload.to_date`	`string`	Yes	—	End date (inclusive) for the report, e.g. 2024-12-20. This date cannot be more than 30 days after from_date (for a maximum queried period of 31 days). Format: `date`.
`payload.filter`	`array`	No	—	Filter criteria to apply when retrieving the usage cost report. Currently, only filtering by resource tags is supported.

Output reference

Standard tool result payload.

Name	Type	Required	Default	Details
`result.data`	`object`	Yes	—	Provider response payload.
`result.data.status`	`number`	No	—	HTTP status code.
`result.data.requestId`	`string`	No	—	Unique id assigned to every request. UUIDv4 Format: `uuid`.
`result.data.result`	`object`	No	—	—
`result.data.result.grandTotalCHC`	`number`	No	—	Grand total cost of usage in ClickHouse Credits (CHCs).
`result.data.result.costs`	`array`	No	—	List of daily, per-entity usage cost records.
`result.data.result.costs[].dataWarehouseId`	`string`	No	—	ID of the dataWarehouse this entity belongs to (or is). Format: `uuid`.
`result.data.result.costs[].serviceId`	`string \| null`	No	—	ID of the service this entity belongs to (or is). Set to null for dataWarehouse entities. Format: `uuid`.
`result.data.result.costs[].date`	`string`	No	—	Date of the usage. ISO-8601 date, based on the UTC timezone. Format: `date`.
`result.data.result.costs[].entityType`	`"datawarehouse" \| "service" \| "clickpipe"`	No	—	Type of the entity. Allowed: `datawarehouse`, `service`, `clickpipe`.
`result.data.result.costs[].entityId`	`string`	No	—	Unique ID of the entity. Format: `uuid`.
`result.data.result.costs[].entityName`	`string`	No	—	Name of the entity.
`result.data.result.costs[].metrics`	`object`	No	—	—
`result.data.result.costs[].metrics.storageCHC`	`number`	No	—	Cost of storage in ClickHouse Credits (CHCs). Applies to dataWarehouse entities.
`result.data.result.costs[].metrics.backupCHC`	`number`	No	—	Cost of backup in ClickHouse Credits (CHCs). Applies to dataWarehouse entities.
`result.data.result.costs[].metrics.computeCHC`	`number`	No	—	Cost of compute in ClickHouse Credits (CHCs). Applies to service and clickpipe entities.
`result.data.result.costs[].metrics.dataTransferCHC`	`number`	No	—	Cost of data transfer in ClickHouse Credits (CHCs). Applies to clickpipe entities.
`result.data.result.costs[].metrics.initialLoadCHC`	`number`	No	—	Cost of initial load and resyncs in ClickHouse Credits (CHCs). Applies to clickpipe entities.
`result.data.result.costs[].metrics.publicDataTransferCHC`	`number`	No	—	Cost of data transfer in ClickHouse Credits (CHCs). Applies to service entities.
`result.data.result.costs[].metrics.interRegionTier1DataTransferCHC`	`number`	No	—	Cost of tier1 inter-region data transfer in ClickHouse Credits (CHCs). Applies to service entities.
`result.data.result.costs[].metrics.interRegionTier2DataTransferCHC`	`number`	No	—	Cost of tier2 inter-region data transfer in ClickHouse Credits (CHCs). Applies to service entities.
`result.data.result.costs[].metrics.interRegionTier3DataTransferCHC`	`number`	No	—	Cost of tier3 inter-region data transfer in ClickHouse Credits (CHCs). Applies to service entities.
`result.data.result.costs[].metrics.interRegionTier4DataTransferCHC`	`number`	No	—	Cost of tier4 inter-region data transfer in ClickHouse Credits (CHCs). Applies to service entities.
`result.data.result.costs[].totalCHC`	`number`	No	—	Total cost of usage in ClickHouse Credits (CHCs) for this entity.
`result.data.result.costs[].locked`	`boolean`	No	—	When true, the record is immutable. Unlocked records are subject to change until locked.
`result.meta`	`object`	No	—	Additional response metadata (status, paging).

Deepline cost

Pricing model: fixed (per call).
Estimated Deepline credits: 0 per pricing unit.
Provider-native pricing may still exist outside Deepline credit billing.

​Run this action

​CLI

​Example response

​Input reference

​Output reference

​Deepline cost

​Related documentation

Run this action

CLI

Example response

Input reference

Output reference

Deepline cost

Related documentation