update PostgreSQL with Dataflow

Question

Hello experts

I have facing an issue updating date in PostgeSQL using ADF dataflow (AlterRow + Sink)

I the alter row, have a table with multiple rows all flagged to be inserted. When going to the previsualisation, I can see the icon on the left and the number of rows in the headers

When I go to the sink, I have selected Update in the settings and selected the ID column of the table. But when I go then to the Sink preview. All the lines are stilled marked to be updated but in the number of rows it allways says zero and indeed the table is not updated if I aplply this dataflow in a pipeline.

I have no clue why

Does anybody knows why ?
Thanks

Answer 1

Hi @Paul-Emmanuel BREC ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your issue, you are trying to update data in postgreSQL using Alter Row transformation in mapping dataflow . However, it is not working as expected in your case. Please let me know if my understanding is incorrect.

I tried to replicate your scenario and was successfully able to update the table in my postgreSQL database using mapping dataflow.

Kindly make sure that columns between source and sink dataset are mapped properly in mapping tab of sink transformation. Also, use Cast transformation to make the datatype of source similar to the schema of sink table in postgre .

Here is the video you can refer to:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button and take satisfaction survey whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators