Skip to main content

pipelines

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

Overview

Namepipelines
TypeResource
Idazure.iot_data_processor.pipelines

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, instanceName, pipelineNameGet a Pipeline
create_or_updateinsertsubscriptionId, resourceGroupName, instanceName, pipelineName, data__extendedLocationCreate a Pipeline
updateupdatesubscriptionId, resourceGroupName, instanceName, pipelineNameUpdate a Pipeline
deletedeletesubscriptionId, resourceGroupName, instanceName, pipelineNameDelete a Pipeline

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.
pipelineNamestringName of pipeline
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a Pipeline

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

INSERT examples

Create a Pipeline

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

UPDATE examples

Update a Pipeline

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

DELETE examples

Delete a Pipeline

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