Skip to main content

dataflows

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

Overview

Namedataflows
TypeResource
Idazure.iotoperations.dataflows

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
extendedLocationobjectEdge location of the resource.
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, instanceName, dataflowProfileName, dataflowNameGet a DataflowResource
list_by_profile_resourceselectsubscriptionId, resourceGroupName, instanceName, dataflowProfileNameList DataflowResource resources by DataflowProfileResource
create_or_updateinsertsubscriptionId, resourceGroupName, instanceName, dataflowProfileName, dataflowName, data__extendedLocationCreate a DataflowResource
deletedeletesubscriptionId, resourceGroupName, instanceName, dataflowProfileName, dataflowNameDelete a DataflowResource

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
dataflowNamestringName of Instance dataflowProfile dataflow resource
dataflowProfileNamestringName of Instance dataflowProfile resource
instanceNamestringName of instance.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a DataflowResource

SELECT
extendedLocation,
properties
FROM azure.iotoperations.dataflows
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND instanceName = '{{ instanceName }}' -- required
AND dataflowProfileName = '{{ dataflowProfileName }}' -- required
AND dataflowName = '{{ dataflowName }}' -- required
;

INSERT examples

Create a DataflowResource

INSERT INTO azure.iotoperations.dataflows (
data__properties,
data__extendedLocation,
subscriptionId,
resourceGroupName,
instanceName,
dataflowProfileName,
dataflowName
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ instanceName }}',
'{{ dataflowProfileName }}',
'{{ dataflowName }}'
RETURNING
extendedLocation,
properties
;

DELETE examples

Delete a DataflowResource

DELETE FROM azure.iotoperations.dataflows
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND instanceName = '{{ instanceName }}' --required
AND dataflowProfileName = '{{ dataflowProfileName }}' --required
AND dataflowName = '{{ dataflowName }}' --required
;