Skip to main content

instances

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

Overview

Nameinstances
TypeResource
Idazure.device_update.instances

Fields

The following fields are returned by SELECT queries:

Instance details.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectDevice Update instance properties.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, subscriptionId, accountName, instanceNameReturns instance details for the given instance and account name.
list_by_accountselectresourceGroupName, subscriptionId, accountNameReturns instances for the given account name.
createinsertresourceGroupName, subscriptionId, accountName, instanceName, data__propertiesCreates or updates instance.
updateupdateresourceGroupName, subscriptionId, accountName, instanceNameUpdates instance's tags.
deletedeleteresourceGroupName, subscriptionId, accountName, instanceNameDeletes 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
accountNamestringAccount name.
instanceNamestringInstance name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Returns instance details for the given instance and account name.

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

INSERT examples

Creates or updates instance.

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

UPDATE examples

Updates instance's tags.

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

DELETE examples

Deletes instance.

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