kafka_connects

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

Overview

Name	kafka_connects
Type	Resource
Id	ovh.cloud_database.kafka_connects

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 kafkaConnect cluster properties
list	select	service_name	x_pagination_mode	List all the kafkaConnect of the project
create	insert	service_name		Create a new kafkaConnect cluster
update	update	cluster_id, service_name		Update an existing kafkaConnect cluster
delete	delete	cluster_id, service_name		Delete a kafkaConnect cluster
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 kafkaConnect 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.kafka_connects
WHERE cluster_id = '{{ cluster_id }}' -- required
AND service_name = '{{ service_name }}' -- required unless OVH_CLOUD_PROJECT_SERVICE is set
;

list

List all the kafkaConnect 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.kafka_connects
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 kafkaConnect cluster

INSERT INTO ovh.cloud_database.kafka_connects (
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: kafka_connects
props:
  - name: service_name
    value: "{{ service_name }}"
    description: Required parameter for the kafka_connects 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 kafkaConnect cluster

UPDATE ovh.cloud_database.kafka_connects
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 kafkaConnect cluster

DELETE FROM ovh.cloud_database.kafka_connects
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.

log_url

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

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