Skip to main content

pipelines

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

Overview

Namepipelines
TypeResource
Idazure.iot_data_processor.pipelines

Fields

NameDatatypeDescription
descriptiontextfield from the properties object
enabledtextfield from the properties object
extended_locationtextfield from the properties object
inputtextfield from the properties object
instanceNametextfield from the properties object
locationtextThe geo-location where the resource lives
pipelineNametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
stagestextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.

Methods

NameAccessible byRequired ParamsDescription
getSELECTinstanceName, pipelineName, resourceGroupName, subscriptionIdGet a Pipeline
create_or_updateINSERTinstanceName, pipelineName, resourceGroupName, subscriptionId, data__extendedLocationCreate a Pipeline
deleteDELETEinstanceName, pipelineName, resourceGroupName, subscriptionIdDelete a Pipeline
updateUPDATEinstanceName, pipelineName, resourceGroupName, subscriptionIdUpdate a Pipeline

SELECT examples

Get a Pipeline

SELECT
description,
enabled,
extended_location,
input,
instanceName,
location,
pipelineName,
provisioning_state,
resourceGroupName,
stages,
subscriptionId,
tags
FROM azure.iot_data_processor.vw_pipelines
WHERE instanceName = '{{ instanceName }}'
AND pipelineName = '{{ pipelineName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

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

UPDATE example

Updates a pipelines resource.

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

DELETE example

Deletes the specified pipelines resource.

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