ADF Pipelines and Triggers

Question

Lets assume a scenario where pipeline A runs every day and pipeline B runs once in every month and it is dependent on pipeline A (pipeline B should trigger after successful completion of pipeline A).

Using scheduled trigger, we cannot have hard dependencies between 2 pipelines, where as with tumbling window, we cannot exactly specify the day which the pipeline B should run(it has only two options, minutes and hours where as scheduled trigger has months and weeks also)

Both the triggers has its disadvantages with respect to this scenario.

What could be the best possible solution for this scenario?

Answer 1

You can Run Pipeline A everyday, and have an IF check that checks if its a specific date today, then run Pipeline B if TRUE and nothing if FALSE.

For the settings of If Condition, you can use this as variable, if you want to run it every 1st of every month:

@Contains('01',Substring(formatDateTime(utcnow()),8,2))