Azure data factory Data flow - Sink ordering

Question

Hi,

I need your guidance in Custom sink ordering in data flow.

I set the sink order starting from 1 but data flow automatically set as '0' for one of the sink. Is it expected ? I hope zero means it would execute first before other sink that is set as '1'

Also, I couldn't modify the order position once I set. Why ? Please explain. I don't see more documentation to explain about sink ordering in detail. I am surprised.

Answer 1

Hello @Seenuvasan, Venkatanathan !

Yes the default order starts from 0

The sink with the lowest order value executes first, followed by sinks with higher order values. The default order value for a sink is 0 if it is not explicitly set.

No you cannot make modifications , you have to recreate the dataflow in each case , thats why you cannot make changes in the order.

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards