Skip to main content

schema_registries

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

Overview

Nameschema_registries
TypeResource
Idgoogle.managedkafka.schema_registries

Fields

The following fields are returned by SELECT queries:

Successful response

NameDatatypeDescription
namestringIdentifier. The name of the schema registry instance. Structured like: projects/{project}/locations/{location}/schemaRegistries/{schema_registry} The instance name {schema_registry} can contain the following: * Up to 255 characters. * Letters (uppercase or lowercase), numbers, and underscores.
contextsarrayOutput only. The contexts of the schema registry instance.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectprojectsId, locationsId, schemaRegistriesIdGet the schema registry instance.
listselectprojectsId, locationsIdviewList schema registries.
createinsertprojectsId, locationsIdCreate a schema registry instance.
deletedeleteprojectsId, locationsId, schemaRegistriesIdDelete a schema registry instance.

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.

NameDatatypeDescription
locationsIdstring
projectsIdstring
schemaRegistriesIdstring
viewstring

SELECT examples

Get the schema registry instance.

SELECT
name,
contexts
FROM google.managedkafka.schema_registries
WHERE projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND schemaRegistriesId = '{{ schemaRegistriesId }}' -- required;

INSERT examples

Create a schema registry instance.

INSERT INTO google.managedkafka.schema_registries (
data__schemaRegistryId,
data__schemaRegistry,
projectsId,
locationsId
)
SELECT
'{{ schemaRegistryId }}',
'{{ schemaRegistry }}',
'{{ projectsId }}',
'{{ locationsId }}'
RETURNING
name,
contexts
;

DELETE examples

Delete a schema registry instance.

DELETE FROM google.managedkafka.schema_registries
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND schemaRegistriesId = '{{ schemaRegistriesId }}' --required;