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:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
descriptionstringHuman-readable description of the schema.
hashstringHash of the schema content.
provisioningStatestringProvisioning state of the resource. Known values are: "Succeeded", "Failed", "Canceled", "Accepted", and "Deleting". (Succeeded, Failed, Canceled, Accepted, Deleting)
schemaContentstringSchema content. Required.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
uuidstringGlobally unique, immutable, non-reusable id.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, schema_registry_name, schema_name, schema_version_name, subscription_idGet a SchemaVersion.
list_by_schemaselectresource_group_name, schema_registry_name, schema_name, subscription_idList SchemaVersion resources by Schema.
create_or_replaceinsertresource_group_name, schema_registry_name, schema_name, schema_version_name, subscription_idCreate a SchemaVersion.
create_or_replacereplaceresource_group_name, schema_registry_name, schema_name, schema_version_name, subscription_idCreate a SchemaVersion.
deletedeleteresource_group_name, schema_registry_name, schema_name, schema_version_name, subscription_idDelete 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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
schema_namestringSchema name parameter. Required.
schema_registry_namestringSchema registry name parameter. Required.
schema_version_namestringSchema version name parameter. Required.
subscription_idstring

SELECT examples

Get a SchemaVersion.

SELECT
id,
name,
description,
hash,
provisioningState,
schemaContent,
systemData,
type,
uuid
FROM azure.device_registry.schema_versions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND schema_registry_name = '{{ schema_registry_name }}' -- required
AND schema_name = '{{ schema_name }}' -- required
AND schema_version_name = '{{ schema_version_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a SchemaVersion.

INSERT INTO azure.device_registry.schema_versions (
properties,
resource_group_name,
schema_registry_name,
schema_name,
schema_version_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ schema_registry_name }}',
'{{ schema_name }}',
'{{ schema_version_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create a SchemaVersion.

REPLACE azure.device_registry.schema_versions
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND schema_registry_name = '{{ schema_registry_name }}' --required
AND schema_name = '{{ schema_name }}' --required
AND schema_version_name = '{{ schema_version_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a SchemaVersion.

DELETE FROM azure.device_registry.schema_versions
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND schema_registry_name = '{{ schema_registry_name }}' --required
AND schema_name = '{{ schema_name }}' --required
AND schema_version_name = '{{ schema_version_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;