You have the Azure Synapse Analytics pipeline shown in the following exhibit.
You need to add a set variable activity to the pipeline to ensure that after the pipeline's completion, the status of the pipeline is always successful.
What should you configure for the set variable activity?
Tumbling window self-dependency properties
In scenarios where the trigger shouldn't proceed to the next window until the preceding window is successfully completed, build a self-dependency. A self-dependency trigger that's dependent on the success of earlier runs of itself within the preceding hour will have the properties indicated in the following code.
Example code:
'name': 'DemoSelfDependency',
'properties': {
'runtimeState': 'Started',
'pipeline': {
'pipelineReference': {
'referenceName': 'Demo',
'type': 'PipelineReference'
}
},
'type': 'TumblingWindowTrigger',
'typeProperties': {
'frequency': 'Hour',
'interval': 1,
'startTime': '2018-10-04T00:00:00Z',
'delay': '00:01:00',
'maxConcurrency': 50,
'retryPolicy': {
'intervalInSeconds': 30
},
'dependsOn': [
{
'type': 'SelfDependencyTumblingWindowTriggerReference',
'size': '01:00:00',
'offset': '-01:00:00'
}
]
}
}
}
Ellen
2 months agoLashaunda
2 months agoMammie
24 days agoDong
26 days agoTyra
1 months agoKina
2 months agoJuan
21 days agoRaul
1 months agoGeorgeanna
2 months agoKyoko
2 months agoJustine
10 days agoJerlene
25 days agoSean
29 days agoCherri
2 months agoCecily
3 months agoMicaela
3 months agoMillie
3 months agoFlorinda
1 months agoStefan
2 months agoCecily
3 months ago