Operationalize and Provide SLA for Data Pipelines

Published Sep 20 2021 09:21 AM 3,811 Views

Azure Data Factory is loved and trusted by corporations around the world. As Azure's native cloud ETL service for scale-out server-less data integration and data transformation, it is widely used to implement Data Pipelines to prepare, process, and load data into enterprise data warehouse or data lake.

 

Typically, data pipelines run on auto-pilot, and are scheduled to run on a predefined timetable, using Schedule Trigger or Tumbling Window Trigger. And sometimes, these pipeline pipelines run mission critical workloads, preparing data for business reports or data analytics/machine learning projects.

 

There are two major challenges delivering service level agreements (SLAs) for these data pipelines:

  1. Compute environment for one activity, for instance SQL for a Stored Procedure activity, may throttle, slowing down the whole data pipeline and missing pipeline SLA.
  2. Pipeline developers aren't always actively monitoring the factory, and proactively seeking out long running pipelines that will miss SLAs.

 

To address these issues, today we are introducing the Elapsed Time Pipeline Run metric. Combined with Data Factory Alerts, we will empower data pipelines developers to better deliver SLAs to their customers: you tell us how long a pipeline should run, and we will notify you, proactively, when the pipeline runs longer than expected.

 

For each pipeline you want to create alerts on, during authoring phase, go to pipeline settings (by clicking on the blank space in the pipeline canvas). 

01 Set Elapsed Time Metric.png

Under Settings tab, check Elapsed time metric, and specify expected pipeline run duration. We strongly recommend you to set this to your business SLA, the amount of time that the pipeline can take to meet your business needs. Once the pipeline duration exceeds this setting, Data Factory will log am Elapsed Time Pipeline Run metric (metric id: PipelineElapsedTimeRuns) in Azure Monitor. In other words, you will get notified about long running pipelines proactively, before the pipeline eventually finishes.

 

Furthermore, follow the steps for Data Factory Alerts to set up alerts on the metric. Engineers will get notified to intervene and take steps to meet the SLAs, through emails or SMSs

 

We understand some pipelines will naturally take more time to finish than others, (like those with more steps, or moving more data), and there is no one-size-fit-all definition for long running pipelines. We kindly ask you to define the threshold for every pipeline that you need a SLA on. And when logging the metric for a particular pipeline, we will compare to its user-defined setting for expected run duration.

 

Note: this is an opt-in feature. No metric will ever be logged for a pipeline, if no expected run duration is specified for the aforementioned pipeline.

 

Official Data Factory Documentation Link: https://docs.microsoft.com/azure/data-factory/tutorial-operationalize-pipelines

3 Comments
Occasional Visitor

@ChenyeCharlieZhu Is this availble in North Europe region

@Pratap_Ganji it is generally available in all regions for Azure Data Factory. Synapse pipeline integration will come at a later date (pending addition to Synapses metrics list)

Occasional Visitor

Any plans to have it look at the average runtime over the past 2 or 7 or 14 or 30 days and if it is more than 1 deviation away from average, then throw a metric?

%3CLINGO-SUB%20id%3D%22lingo-sub-2769983%22%20slang%3D%22en-US%22%3ERe%3A%20Operationalize%20and%20Provide%20SLA%20for%20Data%20Pipelines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2769983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416390%22%20target%3D%22_blank%22%3E%40ChenyeCharlieZhu%3C%2FA%3E%26nbsp%3BIs%20this%20availble%20in%20North%20Europe%20region%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2772476%22%20slang%3D%22en-US%22%3ERe%3A%20Operationalize%20and%20Provide%20SLA%20for%20Data%20Pipelines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1162095%22%20target%3D%22_blank%22%3E%40Pratap_Ganji%3C%2FA%3E%26nbsp%3Bit%20is%20generally%20available%20in%20all%20regions%20for%20Azure%20Data%20Factory.%20Synapse%20pipeline%20integration%20will%20come%20at%20a%20later%20date%20(pending%20addition%20to%20Synapses%20metrics%20list)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2767768%22%20slang%3D%22en-US%22%3EOperationalize%20and%20Provide%20SLA%20for%20Data%20Pipelines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2767768%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Data%20Factory%20is%20loved%20and%20trusted%20by%20corporations%20around%20the%20world.%20As%26nbsp%3B%3CSPAN%3EAzure's%20native%20cloud%20ETL%20service%20for%20scale-out%20server-less%20data%20integration%20and%20data%20transformation%2C%20it%20is%20widely%20used%20to%20implement%20Data%20Pipelines%20to%20prepare%2C%20process%2C%20and%20load%20data%20into%20enterprise%20data%20warehouse%20or%20data%20lake.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ETypically%2C%20data%20pipelines%20run%20on%20auto-pilot%2C%20and%20are%20scheduled%20to%20run%20on%20a%20predefined%20timetable%2C%20using%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-create-schedule-trigger%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESchedule%20Trigger%3C%2FA%3E%26nbsp%3Bor%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fhow-to-create-tumbling-window-trigger%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ETumbling%20Window%20Trigger%3C%2FA%3E.%20And%20sometimes%2C%20these%20pipeline%20pipelines%20run%20mission%20critical%20workloads%2C%20preparing%20data%20for%20business%20reports%20or%20data%20analytics%2Fmachine%20learning%20projects.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20two%20major%20challenges%20delivering%20service%20level%20agreements%20(SLAs)%20for%20these%20data%20pipelines%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3ECompute%20environment%20for%20one%20activity%2C%20for%20instance%20SQL%20for%20a%20Stored%20Procedure%20activity%2C%20may%20throttle%2C%20slowing%20down%20the%20whole%20data%20pipeline%20and%20missing%20pipeline%20SLA.%3C%2FLI%3E%0A%3CLI%3EPipeline%20developers%20aren't%20always%20actively%20monitoring%20the%20factory%2C%20and%20proactively%20seeking%20out%20long%20running%20pipelines%20that%20will%20miss%20SLAs.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20address%20these%20issues%2C%20today%20we%20are%20introducing%20the%20%3CEM%3EElapsed%26nbsp%3BTime%26nbsp%3BPipeline%26nbsp%3BRun%26nbsp%3B%3C%2FEM%3Emetric.%20Combined%20with%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fmonitor-metrics-alerts%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EData%20Factory%20Alerts%3C%2FA%3E%2C%20we%20will%20empower%20data%20pipelines%20developers%20to%20better%20deliver%20SLAs%20to%20their%20customers%3A%20you%20tell%20us%20how%20long%20a%20pipeline%20%3CEM%3Eshould%3C%2FEM%3E%20run%2C%20and%20we%20will%20notify%20you%2C%26nbsp%3B%3CSTRONG%3Eproactively%3C%2FSTRONG%3E%2C%20when%20the%20pipeline%20runs%20longer%20than%20expected.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20%3CEM%3Eeach%3C%2FEM%3E%20pipeline%20you%20want%20to%20create%20alerts%20on%2C%20during%20authoring%20phase%2C%20go%20to%20pipeline%20settings%20(by%20clicking%20on%20the%20blank%20space%20in%20the%20pipeline%20canvas).%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%2201%20Set%20Elapsed%20Time%20Metric.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311609i16B6FA4F033C027A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%2201%20Set%20Elapsed%20Time%20Metric.png%22%20alt%3D%2201%20Set%20Elapsed%20Time%20Metric.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3EUnder%20Settings%20tab%2C%20check%20Elapsed%20time%20metric%2C%20and%20specify%20%3C%2FSPAN%3E%3CEM%20style%3D%22font-family%3A%20inherit%3B%22%3Eexpected%26nbsp%3B%3C%2FEM%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3Epipeline%20run%20duration.%20We%20strongly%20recommend%20you%20to%20set%20this%20to%20your%20business%20SLA%2C%20the%20amount%20of%20time%20that%20the%20pipeline%20can%20take%20to%20meet%20your%20business%20needs.%20Once%20the%20pipeline%20duration%20exceeds%20this%20setting%2C%20Data%20Factory%20will%20log%20am%26nbsp%3B%3C%2FSPAN%3E%3CEM%20style%3D%22font-family%3A%20inherit%3B%22%3EElapsed%26nbsp%3BTime%26nbsp%3BPipeline%26nbsp%3BRun%26nbsp%3B%3C%2FEM%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3Emetric%20(metric%20id%3A%20PipelineElapsedTimeRuns)%20in%20Azure%20Monitor.%20In%20other%20words%2C%20you%20will%20get%20notified%20about%20long%20running%20pipelines%20%3C%2FSPAN%3E%3CSTRONG%20style%3D%22font-family%3A%20inherit%3B%22%3Eproactively%3C%2FSTRONG%3E%3CSPAN%20style%3D%22font-family%3A%20inherit%3B%22%3E%2C%20before%20the%20pipeline%20eventually%20finishes.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFurthermore%2C%20follow%20the%20steps%20for%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fmonitor-metrics-alerts%23data-factory-alerts%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EData%20Factory%20Alerts%3C%2FA%3E%26nbsp%3Bto%20set%20up%20alerts%20on%20the%20metric.%20Engineers%20will%20get%20notified%20to%20intervene%20and%20take%20steps%20to%20meet%20the%20SLAs%2C%20through%20emails%20or%20SMSs%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20understand%20some%20pipelines%20will%20naturally%20take%20more%20time%20to%20finish%20than%20others%2C%20(like%20those%20with%20more%20steps%2C%20or%20moving%20more%20data)%2C%20and%20there%20is%20no%20one-size-fit-all%20definition%20for%20%3CEM%3Elong%20running%20%3C%2FEM%3Epipelines.%20We%20kindly%20ask%20you%20to%20define%20the%20threshold%20for%20every%20pipeline%20that%20you%20need%20a%20SLA%20on.%20And%20when%20logging%20the%20metric%20for%20a%20particular%20pipeline%2C%20we%20will%20compare%20to%20its%20user-defined%20setting%20for%20expected%20run%20duration.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENote%3A%20this%20is%20an%20opt-in%20feature.%20No%20metric%20will%20ever%20be%20logged%20for%20a%20pipeline%2C%20if%20no%20expected%20run%20duration%20is%20specified%20for%20the%20aforementioned%20pipeline.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOfficial%20Data%20Factory%20Documentation%20Link%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Ftutorial-operationalize-pipelines%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Ftutorial-operationalize-pipelines%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2767768%22%20slang%3D%22en-US%22%3E%3CP%3EAvoid%20long%20running%20pipelines.%20Define%20%3CEM%3EElapsed%20Time%20Metric%3C%2FEM%3E%20for%20pipelines%20to%20monitor%20long%20running%20pipelines%2C%20notify%20engineers%20to%20intervene%2C%20and%20send%20out%20service%20emails.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2767768%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20ETL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esla%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2780085%22%20slang%3D%22en-US%22%3ERe%3A%20Operationalize%20and%20Provide%20SLA%20for%20Data%20Pipelines%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2780085%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20plans%20to%20have%20it%20look%20at%20the%20average%20runtime%20over%20the%20past%202%20or%207%20or%2014%20or%2030%20days%20and%20if%20it%20is%20more%20than%201%20deviation%20away%20from%20average%2C%20then%20throw%20a%20metric%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Sep 25 2021 12:24 AM
Updated by: