Skip to main content

pipelines_runs

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

Overview

Namepipelines_runs
TypeResource
Idazure.data_factory.pipelines_runs

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertsubscriptionId, resourceGroupName, factoryName, pipelineNameapi-version, referencePipelineRunId, isRecovery, startActivityName, startFromFailureCreates a run of 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
factoryNamestringThe factory name.
pipelineNamestringThe pipeline name.
resourceGroupNamestringThe resource group name.
subscriptionIdstringThe subscription identifier.
api-versionstringThe API version.
isRecoverybooleanRecovery mode flag. If recovery mode is set to true, the specified referenced pipeline run and the new run will be grouped under the same groupId.
referencePipelineRunIdstringThe pipeline run identifier. If run ID is specified the parameters of the specified run will be used to create a new run.
startActivityNamestringIn recovery mode, the rerun will start from this activity. If not specified, all activities will run.
startFromFailurebooleanIn recovery mode, if set to true, the rerun will start from failed activities. The property will be used only if startActivityName is not specified.

INSERT examples

Creates a run of a pipeline.

INSERT INTO azure.data_factory.pipelines_runs (
subscriptionId,
resourceGroupName,
factoryName,
pipelineName,
api-version,
referencePipelineRunId,
isRecovery,
startActivityName,
startFromFailure
)
SELECT
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ factoryName }}',
'{{ pipelineName }}',
'{{ api-version }}',
'{{ referencePipelineRunId }}',
'{{ isRecovery }}',
'{{ startActivityName }}',
'{{ startFromFailure }}'
RETURNING
runId
;