Skip to main content

schema_registries

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

Overview

Nameschema_registries
TypeResource
Idazure.device_registry.schema_registries

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
identityobjectThe managed service identities assigned to this resource.
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, schemaRegistryNameGet a SchemaRegistry
list_by_resource_groupselectsubscriptionId, resourceGroupNameList SchemaRegistry resources by resource group
list_by_subscriptionselectsubscriptionIdList SchemaRegistry resources by subscription ID
create_or_replaceinsertsubscriptionId, resourceGroupName, schemaRegistryNameCreate a SchemaRegistry
updateupdatesubscriptionId, resourceGroupName, schemaRegistryNameUpdate a SchemaRegistry
deletedeletesubscriptionId, resourceGroupName, schemaRegistryNameDelete a SchemaRegistry

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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
schemaRegistryNamestringSchema registry name parameter.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a SchemaRegistry

SELECT
identity,
location,
properties,
tags
FROM azure.device_registry.schema_registries
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND schemaRegistryName = '{{ schemaRegistryName }}' -- required
;

INSERT examples

Create a SchemaRegistry

INSERT INTO azure.device_registry.schema_registries (
data__properties,
data__identity,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
schemaRegistryName
)
SELECT
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ schemaRegistryName }}'
RETURNING
identity,
location,
properties,
tags
;

UPDATE examples

Update a SchemaRegistry

UPDATE azure.device_registry.schema_registries
SET
data__identity = '{{ identity }}',
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND schemaRegistryName = '{{ schemaRegistryName }}' --required
RETURNING
identity,
location,
properties,
tags;

DELETE examples

Delete a SchemaRegistry

DELETE FROM azure.device_registry.schema_registries
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND schemaRegistryName = '{{ schemaRegistryName }}' --required
;