Hi Team,
I would like to propose an enhancement for Azure Data Factory (ADF) triggers: the ability to add a Gate Condition before a trigger executes.
Currently, ADF triggers (such as schedule triggers) do not allow conditional logic beyond basic recurrence settings. This limits flexibility for scenarios where execution needs to be controlled dynamically.
Example Use Case: A user wants a pipeline to run on all weekdays of the month except the 1st day of the month. With the current setup, this requires complex workarounds like multiple triggers or custom logic inside the pipeline. A gate condition at the trigger level would simplify this by allowing an expression such as:
if (dayOfMonth() != 1 && dayOfWeek() in ('Mon','Tue','Wed','Thu','Fri')) then execute
Benefits:
- Reduces complexity by avoiding multiple triggers or pipeline-level checks.
- Improves maintainability and readability of scheduling logic.
- Enables advanced scheduling scenarios without custom code.
Could you please consider adding this capability in future updates? It would greatly enhance ADF’s flexibility for enterprise scheduling requirements.
Thank you!