clickhouses

Creates, updates, deletes, gets or lists a clickhouses resource.

Overview

Name	clickhouses
Type	Resource
Id	ovh.cloud_database.clickhouses

Fields

The following fields are returned by SELECT queries:

get

successful operation

Name	Datatype	Description
id	string (uuid)	Service ID
network_id	string (uuid)	Private network ID in which the cluster is (wire: networkId)
subnet_id	string (uuid)	Private subnet ID in which the cluster is (wire: subnetId)
backup_time	string (time)	Time on which backups start every day. DEPRECATED: use backups.time (example: 15:04:05) (wire: backupTime)
backups	object	Information related to the backups, null if the engine does not support backups
capabilities	object	Capabilities of the services
category	string	Category of the engine (analysis, operational, streaming)
created_at	string (date-time)	Date of the creation of the cluster (wire: createdAt)
deletion_protection	boolean	Enable deletion protection (wire: deletionProtection)
description	string	Description of the cluster
disk	object	Disk attributes of the cluster. DEPRECATED: use storage
enable_prometheus	boolean	Enable Prometheus (wire: enablePrometheus)
endpoints	array	List of all endpoints of the service
engine	string	Name of the engine of the service (clickhouse, grafana, kafka, kafkaConnect, kafkaMirrorMaker, mongodb, mysql, opensearch, postgresql, valkey)
flavor	string	The VM flavor used for this cluster
ip_restrictions	array	IP Blocks authorized to access to the cluster (wire: ipRestrictions)
maintenance_time	string (time)	Time on which maintenances can start every day (example: 15:04:05) (wire: maintenanceTime)
network_type	string	Type of network of the cluster (private, public) (wire: networkType)
node_number	integer	Number of nodes in the cluster. DEPRECATED: use nodes (wire: nodeNumber)
nodes	array	Nodes of the cluster
openstack_region	string	OpenStack region of the cluster (wire: openstackRegion)
plan	string	Plan of the cluster
status	string	Current status of the cluster (CREATING, DELETING, DRAINED, ERROR, LOCKED, LOCKED_PENDING, LOCKED_UPDATING, PENDING, READY, SHELVED, TO_DRAIN, UPDATING)
storage	object	Storage attributes of the cluster
version	string	Version of the engine deployed on the cluster

list

Cloud database service definition

Name	Datatype	Description
id	string (uuid)	Service ID
network_id	string (uuid)	Private network ID in which the cluster is (wire: networkId)
subnet_id	string (uuid)	Private subnet ID in which the cluster is (wire: subnetId)
backup_time	string (time)	Time on which backups start every day. DEPRECATED: use backups.time (example: 15:04:05) (wire: backupTime)
backups	object	Information related to the backups, null if the engine does not support backups
capabilities	object	Capabilities of the services
category	string	Category of the engine (analysis, operational, streaming)
created_at	string (date-time)	Date of the creation of the cluster (wire: createdAt)
deletion_protection	boolean	Enable deletion protection (wire: deletionProtection)
description	string	Description of the cluster
disk	object	Disk attributes of the cluster. DEPRECATED: use storage
enable_prometheus	boolean	Enable Prometheus (wire: enablePrometheus)
endpoints	array	List of all endpoints of the service
engine	string	Name of the engine of the service (clickhouse, grafana, kafka, kafkaConnect, kafkaMirrorMaker, mongodb, mysql, opensearch, postgresql, valkey)
flavor	string	The VM flavor used for this cluster
ip_restrictions	array	IP Blocks authorized to access to the cluster (wire: ipRestrictions)
maintenance_time	string (time)	Time on which maintenances can start every day (example: 15:04:05) (wire: maintenanceTime)
network_type	string	Type of network of the cluster (private, public) (wire: networkType)
node_number	integer	Number of nodes in the cluster. DEPRECATED: use nodes (wire: nodeNumber)
nodes	array	Nodes of the cluster
openstack_region	string	OpenStack region of the cluster (wire: openstackRegion)
plan	string	Plan of the cluster
status	string	Current status of the cluster (CREATING, DELETING, DRAINED, ERROR, LOCKED, LOCKED_PENDING, LOCKED_UPDATING, PENDING, READY, SHELVED, TO_DRAIN, UPDATING)
storage	object	Storage attributes of the cluster
version	string	Version of the engine deployed on the cluster

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	cluster_id, service_name		Get clickhouse cluster properties
list	select	service_name	x_pagination_mode	List all the clickhouse of the project
create	insert	service_name		Create a new clickhouse cluster
update	update	cluster_id, service_name		Update an existing clickhouse cluster
delete	delete	cluster_id, service_name		Delete a clickhouse cluster
enable_writes	exec	clusterId, service_name		Enable temporary write permission on readonly lock clickhouse service
log_url	exec	clusterId, service_name, kind		Generates a temporary URL to read the logs of one kind. The URL expires.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
api_host	string	The OVHcloud API host. Selected by OVH_ENDPOINT (ovh-eu, ovh-ca or ovh-us; default ovh-eu). (default: api.eu.ovhcloud.com, x-stackQL-envVarSelector: {"envVar":"OVH_ENDPOINT","default":"ovh-eu","values":{"ovh-eu":"api.eu.ovhcloud.com","ovh-ca":"api.ca.ovhcloud.com","ovh-us":"api.us.ovhcloud.com"}})
clusterId	string (uuid)	Cluster ID
cluster_id	string (uuid)	Cluster ID (wire: clusterId)
service_name	string	The Public Cloud project ID. Resolved from OVH_CLOUD_PROJECT_SERVICE when set.
x_pagination_mode	string	Sent as CachedObjectList-Pages by default so the list returns the full objects rather than their identifiers. (wire: X-Pagination-Mode)

SELECT examples

get

Get clickhouse cluster properties

SELECT
id,
network_id,
subnet_id,
backup_time,
backups,
capabilities,
category,
created_at,
deletion_protection,
description,
disk,
enable_prometheus,
endpoints,
engine,
flavor,
ip_restrictions,
maintenance_time,
network_type,
node_number,
nodes,
openstack_region,
plan,
status,
storage,
version
FROM ovh.cloud_database.clickhouses
WHERE cluster_id = '{{ cluster_id }}' -- required
AND service_name = '{{ service_name }}' -- required unless OVH_CLOUD_PROJECT_SERVICE is set
;

list

List all the clickhouse of the project

SELECT
id,
network_id,
subnet_id,
backup_time,
backups,
capabilities,
category,
created_at,
deletion_protection,
description,
disk,
enable_prometheus,
endpoints,
engine,
flavor,
ip_restrictions,
maintenance_time,
network_type,
node_number,
nodes,
openstack_region,
plan,
status,
storage,
version
FROM ovh.cloud_database.clickhouses
WHERE service_name = '{{ service_name }}' -- required unless OVH_CLOUD_PROJECT_SERVICE is set
AND x_pagination_mode = '{{ x_pagination_mode }}'
;

INSERT examples

create

Create a new clickhouse cluster

INSERT INTO ovh.cloud_database.clickhouses (
backup,
backup_time,
backups,
description,
disk,
fork_from,
ip_restrictions,
maintenance_time,
network_id,
nodes_list,
nodes_pattern,
plan,
subnet_id,
version,
service_name
)
SELECT 
'{{ backup }}',
'{{ backup_time }}',
'{{ backups }}',
'{{ description }}',
'{{ disk }}',
'{{ fork_from }}',
'{{ ip_restrictions }}',
'{{ maintenance_time }}',
'{{ network_id }}',
'{{ nodes_list }}',
'{{ nodes_pattern }}',
'{{ plan }}',
'{{ subnet_id }}',
'{{ version }}',
'{{ service_name }}'
RETURNING
id,
network_id,
subnet_id,
backup_time,
backups,
capabilities,
category,
created_at,
deletion_protection,
description,
disk,
enable_prometheus,
endpoints,
engine,
flavor,
ip_restrictions,
maintenance_time,
network_type,
node_number,
nodes,
openstack_region,
plan,
status,
storage,
version
;

Manifest

# Description fields are for documentation purposes
- name: clickhouses
props:
  - name: service_name
    value: "{{ service_name }}"
    description: Required parameter for the clickhouses resource.
  - name: backup
    description: |
      Backup from which the new service is created. DEPRECATED: use forkFrom
    value:
      id: "{{ id }}"
      pointInTime: "{{ pointInTime }}"
      serviceId: "{{ serviceId }}"
  - name: backup_time
    value: "{{ backup_time }}"
    description: |
      Time on which backups start every day. DEPRECATED: use backups.time
  - name: backups
    description: |
      Information related to the backups, null if the engine does not support backups
    value:
      pitr: "{{ pitr }}"
      regions:
        - "{{ regions }}"
      retentionDays: {{ retentionDays }}
      time: "{{ time }}"
  - name: description
    value: "{{ description }}"
    description: |
      Description of the cluster
  - name: disk
    description: |
      Disk attributes of the cluster
    value:
      size: {{ size }}
      type: "{{ type }}"
  - name: fork_from
    description: |
      Backup from which the new service is created
    value:
      backupId: "{{ backupId }}"
      pointInTime: "{{ pointInTime }}"
      serviceId: "{{ serviceId }}"
  - name: ip_restrictions
    description: |
      IP Blocks authorized to access to the cluster
    value:
      - description: "{{ description }}"
        ip: "{{ ip }}"
        status: "{{ status }}"
  - name: maintenance_time
    value: "{{ maintenance_time }}"
    description: |
      Time on which maintenances can start every day
  - name: network_id
    value: "{{ network_id }}"
    description: |
      Private network ID in which the cluster is
  - name: nodes_list
    description: |
      List of nodes in the cluster, not compatible with nodesPattern
    value:
      - createdAt: "{{ createdAt }}"
        flavor: "{{ flavor }}"
        id: "{{ id }}"
        name: "{{ name }}"
        port: {{ port }}
        region: "{{ region }}"
        role: "{{ role }}"
        status: "{{ status }}"
  - name: nodes_pattern
    description: |
      Pattern definition of the nodes in the cluster, not compatible with nodesList
    value:
      flavor: "{{ flavor }}"
      number: {{ number }}
      region: "{{ region }}"
  - name: plan
    value: "{{ plan }}"
    description: |
      Plan of the cluster
  - name: subnet_id
    value: "{{ subnet_id }}"
    description: |
      Private subnet ID in which the cluster is
  - name: version
    value: "{{ version }}"
    description: |
      Version of the engine deployed on the cluster

UPDATE examples

update

Update an existing clickhouse cluster

UPDATE ovh.cloud_database.clickhouses
SET 
backup_time = '{{ backup_time }}',
backups = '{{ backups }}',
deletion_protection = {{ deletion_protection }},
description = '{{ description }}',
disk = '{{ disk }}',
enable_prometheus = {{ enable_prometheus }},
flavor = '{{ flavor }}',
ip_restrictions = '{{ ip_restrictions }}',
maintenance_time = '{{ maintenance_time }}',
network_id = '{{ network_id }}',
node_number = {{ node_number }},
plan = '{{ plan }}',
storage = '{{ storage }}',
subnet_id = '{{ subnet_id }}',
version = '{{ version }}'
WHERE 
cluster_id = '{{ cluster_id }}' --required
AND service_name = '{{ service_name }}' --required unless OVH_CLOUD_PROJECT_SERVICE is set
RETURNING
id,
network_id,
subnet_id,
backup_time,
backups,
capabilities,
category,
created_at,
deletion_protection,
description,
disk,
enable_prometheus,
endpoints,
engine,
flavor,
ip_restrictions,
maintenance_time,
network_type,
node_number,
nodes,
openstack_region,
plan,
status,
storage,
version;

DELETE examples

delete

Delete a clickhouse cluster

DELETE FROM ovh.cloud_database.clickhouses
WHERE cluster_id = '{{ cluster_id }}' --required
AND service_name = '{{ service_name }}' --required unless OVH_CLOUD_PROJECT_SERVICE is set
;

Lifecycle Methods

EXEC variables use wire (API) names.

enable_writes

Enable temporary write permission on readonly lock clickhouse service

EXEC ovh.cloud_database.clickhouses.enable_writes 
@clusterId='{{ clusterId }}' --required, 
@service_name='{{ service_name }}' --required unless OVH_CLOUD_PROJECT_SERVICE is set
;

log_url

Generates a temporary URL to read the logs of one kind. The URL expires.

EXEC ovh.cloud_database.clickhouses.log_url 
@clusterId='{{ clusterId }}' --required, 
@service_name='{{ service_name }}' --required unless OVH_CLOUD_PROJECT_SERVICE is set 
@@json=
'{
"kind": "{{ kind }}"
}'
;