question

DattaP-1716 avatar image
0 Votes"
DattaP-1716 asked DattaP-1716 commented

ADF sink transformation not writing the data in sequesnce

I am trying to to reverse the order of the rows. While data preview of Sink transformation, data is getting reversed. But while debug the data is not getting written as seen in sink transformation. There is no error.

Am I missing the setting part? Need you help to resolve the issue.

ADF dataflow configurations.

86837-image.png


  • Output

86933-image.png


azure-data-factory
image.png (86.7 KiB)
image.png (66.4 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @dattap-1716,
Thanks for using Microsoft Q&A !!
I am able to reproduce this issue and reaching out internally to products team and update you back on the same.

Thanks
Saurabh

0 Votes 0 ·

Hope to hear soon

0 Votes 0 ·

@dattap-1716 I have tried with Mark Kromer's suggestion and used single partitioning for both Sort and Sink. It works as expected and the data is being sorted now
87798-image.png
Please try and let us know if you still have issues.


1 Vote 1 ·
image.png (25.1 KiB)
Show more comments

1 Answer

MarkKromer-MSFT avatar image
1 Vote"
MarkKromer-MSFT answered

In the Sort transformation, go to the Optimize tab and set "Single Partition".

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.