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:

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__schemaRegistry,
data__schemaRegistryId,
projectsId,
locationsId
)
SELECT
'{{ schemaRegistry }}',
'{{ schemaRegistryId }}',
'{{ 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
;