Forum Discussion

NewTechy's avatar
NewTechy
Copper Contributor
Mar 09, 2021

Recursive KQL query

I am trying to get an overview of the pipeline-runs in ADFPipelineRun, listing all of the predecessors. As sucht, it would be wonderful to see not only the parent-pipeline, but also the parent of the parent-pipeline, etc...

 

In SQL, it is possible to write a recursive query: https://www.sqlservertutorial.net/sql-server-basics/sql-server-recursive-cte/ Would something similar be possible with KQL?

 

And if not, is there an alternative solution to complete tree of parent-pipelines?

 

Thank you in advance

No RepliesBe the first to reply

Resources