Skip to main content

schema_versions

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

Overview

Nameschema_versions
TypeResource
Idazure.device_registry.schema_versions

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, schemaRegistryName, schemaName, schemaVersionNameGet a SchemaVersion
list_by_schemaselectsubscriptionId, resourceGroupName, schemaRegistryName, schemaNameList SchemaVersion resources by Schema
create_or_replaceinsertsubscriptionId, resourceGroupName, schemaRegistryName, schemaName, schemaVersionNameCreate a SchemaVersion
deletedeletesubscriptionId, resourceGroupName, schemaRegistryName, schemaName, schemaVersionNameDelete a SchemaVersion

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.
schemaNamestringSchema name parameter.
schemaRegistryNamestringSchema registry name parameter.
schemaVersionNamestringSchema version name parameter.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a SchemaVersion

SELECT
properties
FROM azure.device_registry.schema_versions
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND schemaRegistryName = '{{ schemaRegistryName }}' -- required
AND schemaName = '{{ schemaName }}' -- required
AND schemaVersionName = '{{ schemaVersionName }}' -- required
;

INSERT examples

Create a SchemaVersion

INSERT INTO azure.device_registry.schema_versions (
data__properties,
subscriptionId,
resourceGroupName,
schemaRegistryName,
schemaName,
schemaVersionName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ schemaRegistryName }}',
'{{ schemaName }}',
'{{ schemaVersionName }}'
RETURNING
properties
;

DELETE examples

Delete a SchemaVersion

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