Articles in this section

Available ClickHouse APIs

When you configure an export, import, other type of flow step using the prebuilt ClickHouse connector, you can select any of the API operations listed below, organized by API type.

Note

If your API endpoint isn’t listed here, switch the flow step to HTTP mode and configure the endpoint provided in the ClickHouse API documentation. You can also create a composite endpoint for this application in HTTP mode.

Resource

API endpoint

Export

Import

Backup

Create service backup bucket

X

Delete service backup bucket

X

Get backup details

X

Get service backup bucket

X

Get service backup configuration

X

List of service backups

X

Update service backup bucket

X

Update service backup configuration

X

Billing

Get organization usage costs

X

ClickPipes

Create ClickPipe

X

Create reverse private endpoint

X

Delete ClickPipe

X

Delete reverse private endpoint

X

Get CDC ClickPipes scaling

X

Get ClickPipe

X

Get ClickPipe settings

X

Get reverse private endpoint

X

List ClickPipes

X

List reverse private endpoints

X

Update CDC ClickPipes scaling

X

Update ClickPipe

X

Update ClickPipe scaling

X

Update ClickPipe settings

X

Update ClickPipe state

X

Update reverse private endpoint

X

Click stack

Create alert

X

Create dashboard

X

Delete alert

X

Delete dashboard

X

Get alert

X

Get dashboard

X

List alerts

X

List dashboards

X

List sources

X

List webhooks

X

Update alert

X

Update dashboard

X

Open API

Create key

X

Delete key

X

Get key details

X

Get list of all keys

X

Update key

X

Organization

Create BYOC infrastructure

X

Get list of available organizations

X

Get organization details

X

Get private endpoint configuration for region within cloud provider for an organization

X

List of organization activities

X

Organization activity

X

Remove a BYOC infrastructure

X

Update BYOC infrastructure

X

Update organization details

X

Postgres

Create a read replica for a Postgres service

X

Create new Postgres service

X

Delete a PostgreSQL service

X

Get a Postgres slow query pattern with recent executions

X

Get Postgres CA certs

X

Get Postgres time-series metrics

X

Get PostgreSQL service configuration

X

Get PostgreSQL service details

X

List of organization Postgres services

X

List Postgres slow query patterns

X

Replace Postgres service configuration

X

Restore a Postgres service

X

Update a PostgreSQL service

X

Update Postgres service configuration

X

Update Postgres service state

X

Update Postgres superuser password

X

Prometheus

Get organization metrics

X

Get organization PostgreSQL metrics

X

Get PostgreSQL service metrics

X

Get service metrics

X

Role management

Create a new role

X

Delete a role

X

Get role details

X

List all available roles for an organization

X

Update a role

X

Service

Create a private endpoint

X

Create new service

X

Create or replace service autoscaling schedule

X

Delete service

X

Delete service scheduled scaling

X

Delete service upgrade window

X

Delete the service query endpoint for a given instance

X

Get ClickHouse setting

X

Get ClickHouse settings schema

X

Get private endpoint configuration

X

Get service autoscaling schedule

X

Get service details

X

Get service upgrade window

X

Get the service query endpoint for a given instance

X

List ClickHouse settings

X

List of organization services

X

Reset ClickHouse settings to default

X

Set service upgrade window

X

Update ClickHouse settings

X

Update service auto scaling settings (Replica scaling)

X

Update service auto scaling settings (Total scaling)

X

Update service basic details

X

Update service password

X

Update service state

X

Upsert the service query endpoint for a given instance

X

User management

Create an invitation

X

Delete organization invitation

X

Get invitation details

X

Get member details

X

List all invitations

X

List organization members

X

Remove an organization member

X

Update organization member

X