Orchestrating ADF pipelines from synapse

Copper Contributor

Currently we are working to come up with a scheduling architecture for azure data factory pipelines . 

As part of that one of the major requirements that we have is automated dependency detection based on scheduling metadata. 

One of the options that we also evaluated is ADF triggers , however that looks good for our requirements at a small scale . On a mass scale for example around 1800 jobs it looks very effort intensive to manage dependencies via triggers . 

Hence we are looking at some options whereby if we can control and automate dependency using  azure synapse tables and t-SQL procedures and trigger ADF pipelines using t-SQL. 


Looking for other scheduling tools that might meet this criteria . Open to guidance and suggestions. 


0 Replies