CLI ClickHouse Provider

The ClickHouse scanner syncs ClickHouse Cloud instances into Ctrlplane, allowing you to monitor, manage, and deploy to your ClickHouse infrastructure.

Usage

To sync in all ClickHouse instances, you’ll need:

  1. A ClickHouse Cloud API key with read access to your organization
  2. Your ClickHouse organization ID

You can create an API key in the ClickHouse Cloud Console under “API Keys”.

To see all available options, run:

ctrlc sync clickhouse --help

Here is a basic example of how to sync in all ClickHouse instances:

ctrlc sync clickhouse \
    --clickhouse-key <CLICKHOUSE_API_KEY> \
    --organization-id <ORG_ID> \
    --interval 5m

You can also set environment variables for the API key and organization ID:

export CLICKHOUSE_API_KEY=<your-api-key>
export CLICKHOUSE_ORGANIZATION_ID=<your-org-id>
ctrlc sync clickhouse

Resource Schemas

Service

When syncing instances from ClickHouse, each service will have the following schema:

version
string
default:"clickhouse/v1"

The version of the schema

kind
string
default:"Service"

The type of resource

name
string

Name of the service, derived from the ClickHouse service name

identifier
string

The unique identifier of the service, in the format organizationID/serviceID

config
ClickHouse resource config
metadata
ClickHouse resource metadata