I am looking for a solution for the below situation:
I have to extract all the managers (by hierarchy) for some employees that i receive in the flow (we have a file that contains all the information about all the employees and an other that represent the current delta of the flow), context of files they are stored in the datalake (csv files) , i am working with Azure SQL pool of Synapse to query the files. I am not able to use recursive tables (CTE) as it is not supported in Synapse.
Could you have some other ideas to get the ascendants of each employee in the flow? thank you