Azure Data Factory -> Experiencing issues with mapping data flows -> Sink activity for update method

Vivek Komarla Bhaskar 826 Reputation points

When I try to use the update method on sink activity of mapping data flows, the backend table in Synapse of replicate type does not show these updates. Even with the alter row transformation before the sink activity, I can clearly see the record for the update in the data preview, but it doesn't appear in the sink activity data preview. On the sink settings, the key column is set correctly.

  • --Alter RowScreenshot 2023-10-27 at 2.52.59 pm

Screenshot 2023-10-27 at 2.56.03 pm

  • --Sink

Screenshot 2023-10-27 at 2.56.48 pm

Screenshot 2023-10-28 at 12.20.16 pm

Screenshot 2023-10-27 at 2.57.33 pm

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,458 questions
{count} vote