schema_registries

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

Overview

Name	schema_registries
Type	Resource
Id	azure.device_registry.schema_registries

Fields

vw_schema_registries

Name	Datatype	Description
description	text	field from the properties object
display_name	text	field from the properties object
identity	text	Managed service identity (either system assigned, or none)
location	text	The geo-location where the resource lives
namespace	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
schemaRegistryName	text	field from the properties object
storage_account_container_url	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
uuid	text	field from the properties object

schema_registries

Name	Datatype	Description
identity	object	Managed service identity (either system assigned, or none)
location	string	The geo-location where the resource lives
properties	object	Defines the schema registry properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, schemaRegistryName, subscriptionId	Get a SchemaRegistry
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List SchemaRegistry resources by resource group
list_by_subscription	SELECT	subscriptionId	List SchemaRegistry resources by subscription ID
create_or_replace	INSERT	resourceGroupName, schemaRegistryName, subscriptionId	Create a SchemaRegistry
delete	DELETE	resourceGroupName, schemaRegistryName, subscriptionId	Delete a SchemaRegistry
update	UPDATE	resourceGroupName, schemaRegistryName, subscriptionId	Update a SchemaRegistry

SELECT examples

List SchemaRegistry resources by subscription ID

vw_schema_registries

SELECT
description,
display_name,
identity,
location,
namespace,
provisioning_state,
resourceGroupName,
schemaRegistryName,
storage_account_container_url,
subscriptionId,
tags,
uuid
FROM azure.device_registry.vw_schema_registries
WHERE subscriptionId = '{{ subscriptionId }}';

schema_registries

SELECT
identity,
location,
properties,
tags
FROM azure.device_registry.schema_registries
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new schema_registries resource.

All Properties

/*+ create */
INSERT INTO azure.device_registry.schema_registries (
resourceGroupName,
schemaRegistryName,
subscriptionId,
properties,
identity,
tags,
location
)
SELECT 
'{{ resourceGroupName }}',
'{{ schemaRegistryName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: uuid
          value: string
        - name: namespace
          value: string
        - name: displayName
          value: string
        - name: description
          value: string
        - name: storageAccountContainerUrl
          value: string
        - name: provisioningState
          value: []
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a schema_registries resource.

/*+ update */
UPDATE azure.device_registry.schema_registries
SET 
identity = '{{ identity }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND schemaRegistryName = '{{ schemaRegistryName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified schema_registries resource.

/*+ delete */
DELETE FROM azure.device_registry.schema_registries
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND schemaRegistryName = '{{ schemaRegistryName }}'
AND subscriptionId = '{{ subscriptionId }}';