Trigger run and debug mode

Anshal 2,251 Reputation points
2022-09-09T05:54:24.97+00:00

Hi friends why it is important pipeline in debug mode or trigger run in my one of question asked it is asked is it have impact on pipeline

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,099 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,496 Reputation points Microsoft Employee
    2022-09-09T10:34:22.483+00:00

    Hi @Anshal ,

    Thank you for posting query in Microsoft Q&A Platform.

    Debug run:

    • Debug run will execute pipeline with draft changes also, That means lets say you did some changes in pipeline and not published them yet. Still Debug run will execute pipeline by considering that changes as well.
    • Debug Run cannot be scheduled. Its always manual run.

    Trigger run:

    • Trigger run will execute pipeline with published version only. Drafted changes made in the pipeline will not be considered in it.
    • Trigger run can be scheduled. Above are the main difference between debug run and Trigger run in layman terminology

    Now, coming to query, why Microsoft support team asked is it debug run or Trigger run?

    We cannot predict the exact reason behind it, depending on the issue to understand the root cause or to check logs in backend or repro scenario or based on nature of issue it may needed for them to better help with troubleshooting issue.

    Hope this helps. Please let me know if any further queries.


    Please consider hitting Accept Answer button and Up-Vote. Accepted answers help community as well.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Sanjeev Kumar Halladavar 30 Reputation points
    2023-11-22T07:36:25.1733333+00:00

    When you run an Azure Data Factory (ADF) pipeline in trigger mode, it's optimized for execution efficiency because it's executing within the context of a trigger event, often based on predefined conditions or schedules.

    In trigger mode, the pipeline is typically working with production data and configurations, and it aims to complete the tasks as efficiently as possible without pausing for debugging or detailed monitoring.

    On the other hand, when you run the pipeline in debug mode, it might include additional logging, monitoring, and potentially pauses or breakpoints set for debugging purposes. These extra processes can slow down the execution time compared to the streamlined nature of trigger-based executions.

    Debug mode provides more insights into individual activities, allows for testing changes, and helps in identifying issues during development, but it's not optimized for speed or production-like performance.

    Therefore, if performance is a concern and you don't specifically need detailed debugging information, running the pipeline in trigger mode would typically result in faster execution times.

    2 people found this answer helpful.

  2. Nandan Hegde 33,241 Reputation points MVP
    2022-09-09T10:04:22.637+00:00

    Hey,
    There are multiple queries which is asked when a ticket is raised to get some background on the issues which are as below:

    1. Was the pipeline running till date and has suddenly stopped failing
    2. The 2nd scenario is w.r.t debug vs trigger due to below case scenarios:
      a) https://learn.microsoft.com/en-us/answers/questions/841434/azure-data-factory-debug-run-not-working.html
      for debugging in data flows, some setting needs to be done:
      https://learn.microsoft.com/en-us/azure/data-factory/concepts-data-flow-debug-mode?tabs=data-factory

    b) Also, there are scenarios wherein the published version of pipeline is triggered by ADF and not the draft version which is executed in debug.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.