datasets

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

Overview

Name	datasets
Type	Resource
Id	azure.iot_data_processor.datasets

Fields

vw_datasets

Name	Datatype	Description
description	text	field from the properties object
datasetName	text	field from the properties object
extended_location	text	field from the properties object
instanceName	text	field from the properties object
keys	text	field from the properties object
location	text	The geo-location where the resource lives
payload	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
timestamp	text	field from the properties object
ttl	text	field from the properties object

datasets

Name	Datatype	Description
extendedLocation	object	Extended location is an extension of Azure locations. They provide a way to use their Azure ARC enabled Kubernetes clusters as target locations for deploying Azure services instances.
location	string	The geo-location where the resource lives
properties	object	The properties of a Dataset resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	datasetName, instanceName, resourceGroupName, subscriptionId	Get a Dataset
create_or_update	INSERT	datasetName, instanceName, resourceGroupName, subscriptionId, data__extendedLocation	Create a Dataset
delete	DELETE	datasetName, instanceName, resourceGroupName, subscriptionId	Delete a Dataset
update	UPDATE	datasetName, instanceName, resourceGroupName, subscriptionId	Update a Dataset

SELECT examples

Get a Dataset

vw_datasets

SELECT
description,
datasetName,
extended_location,
instanceName,
keys,
location,
payload,
provisioning_state,
resourceGroupName,
subscriptionId,
tags,
timestamp,
ttl
FROM azure.iot_data_processor.vw_datasets
WHERE datasetName = '{{ datasetName }}'
AND instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

datasets

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.iot_data_processor.datasets (
datasetName,
instanceName,
resourceGroupName,
subscriptionId,
data__extendedLocation,
properties,
extendedLocation,
tags,
location
)
SELECT 
'{{ datasetName }}',
'{{ instanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__extendedLocation }}',
'{{ properties }}',
'{{ extendedLocation }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: description
          value: string
        - name: payload
          value: string
        - name: timestamp
          value: string
        - name: ttl
          value: string
        - name: keys
          value: object
        - name: provisioningState
          value: []
    - name: extendedLocation
      value:
        - name: name
          value: string
        - name: type
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a datasets resource.

/*+ update */
UPDATE azure.iot_data_processor.datasets
SET 
tags = '{{ tags }}'
WHERE 
datasetName = '{{ datasetName }}'
AND instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified datasets resource.

/*+ delete */
DELETE FROM azure.iot_data_processor.datasets
WHERE datasetName = '{{ datasetName }}'
AND instanceName = '{{ instanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';