ClickHouse Cloud | Operate As Docs

Connect your client's ClickHouse Cloud with a key they paste, and call its API through Operate As.

Website: clickhouse.com
Connects by: Pasting a Key ID and secret
Category: Developer tools
Services: 1
Tools: 169

Service	Key	Base URL
ClickHouse Cloud	`clickhouse-cloud`	`https://api.clickhouse.cloud/v1`

Connecting

Your client makes a Key ID and secret in their ClickHouse Cloud settings and pastes it on their link. Operate As tries it with ClickHouse Cloud before saving it, and stores it encrypted. See Services connected with an API key.

Check they're connected

curl https://api.operate.as/v1/me/clients \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl https://api.operate.as/v1/me/clients \  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

Response

[
  {
    "id": "6f1c2a7e-...",
    "name": "Miller Dental",
    "services": [
      "clickhouse-cloud"
    ]
  }
]

[  {    "id": "6f1c2a7e-...",    "name": "Miller Dental",    "services": [      "clickhouse-cloud"    ]  }]

Permissions

What the client reads	Permission it asks for
Use the ClickHouse Cloud key you paste, with only the access you gave that key	Chosen on the provider's screen

Tools

Install ClickHouse Cloud's typed package for your language:

pip install operate-as-clickhouse-cloud

pip install operate-as-clickhouse-cloud

Run clickhouse-cloud.activity_get

curl -X POST https://api.operate.as/v1/actions/clickhouse-cloud.activity_get \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "clientId": "6f1c2a7e-...",
    "input": {
      "organization_id": "<organization_id>",
      "activity_id": "<activity_id>"
    }
  }'

curl -X POST https://api.operate.as/v1/actions/clickhouse-cloud.activity_get \  -H "Authorization: Bearer $OPERATE_AS_API_KEY" \  -H "Content-Type: application/json" \  -d '{    "clientId": "6f1c2a7e-...",    "input": {      "organization_id": "<organization_id>",      "activity_id": "<activity_id>"    }  }'

Shows the required inputs. Every input, with its JSON Schema: GET /v1/actions/clickhouse-cloud.activity_get

Response

{
  "status": 200,
  "data": {
    "…": "the service's own response"
  },
  "encoding": "json"
}

{  "status": 200,  "data": {    "…": "the service's own response"  },  "encoding": "json"}

Pass-through

Paths continue from https://api.clickhouse.cloud/v1. Your Operate As key goes in Authorization; the client's access is added for you.

See Pass-through requests for the full request and response format.

Call any endpoint

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../clickhouse-cloud/organizations" \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../clickhouse-cloud/organizations" \  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

Response

{
  "status": 200,
  "data": {
    "…": "the service's own response"
  },
  "encoding": "json"
}

{  "status": 200,  "data": {    "…": "the service's own response"  },  "encoding": "json"}

When access ends

A key works until your client deletes it in ClickHouse Cloud. They can paste a new one on the same link at any time, and your workflows carry on without changes.

See Keeping access alive and Removing access.

Calls answer, once the key is deleted

{
  "status": 401,
  "data": {
    "…": "the service's own error"
  },
  "encoding": "json"
}

{  "status": 401,  "data": {    "…": "the service's own error"  },  "encoding": "json"}