Skip to main content

instances

Creates, updates, deletes, gets or lists an instances resource.

Overview

Nameinstances
TypeResource
Idazure.iot_data_processor.instances

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectEdge location of the 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, instanceNameGet a Instance
list_by_resource_groupselectsubscriptionId, resourceGroupNameList Instance resources by resource group
list_by_subscriptionselectsubscriptionIdList Instance resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, instanceName, data__extendedLocationCreate a Instance
updateupdatesubscriptionId, resourceGroupName, instanceNameUpdate a Instance
deletedeletesubscriptionId, resourceGroupName, instanceNameDelete a 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
instanceNamestringName of instance.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a Instance

SELECT
extendedLocation,
location,
properties,
tags
FROM azure.iot_data_processor.instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND instanceName = '{{ instanceName }}' -- required
;

INSERT examples

Create a Instance

INSERT INTO azure.iot_data_processor.instances (
data__properties,
data__extendedLocation,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
instanceName
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ instanceName }}'
RETURNING
extendedLocation,
location,
properties,
tags
;

UPDATE examples

Update a Instance

UPDATE azure.iot_data_processor.instances
SET
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND instanceName = '{{ instanceName }}' --required
RETURNING
extendedLocation,
location,
properties,
tags;

DELETE examples

Delete a Instance

DELETE FROM azure.iot_data_processor.instances
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND instanceName = '{{ instanceName }}' --required
;