Forum Discussion
NewTechy
Mar 09, 2021Copper Contributor
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