Forum Discussion

Jerome22's avatar
Jerome22
Icon for Resolver I rankResolver I
1 year ago
Solved

updating records using copy job?

Hi,   when Data copy will support updates and not just adding rows? I have a lot of tables which can have updated records, so I want to update my destination not just adding new rows.   thanks.
data engineering
  • Jerome22's avatar
    Jerome22
    1 year ago

    ok... unfortunately it's not supporting deletes.

    and the update appear to update all the rows matching the ID without option to select a hash or timestamp column.

     

    well... I'll still use SQL statements for now. still faster with more control than relying on external tools like the copy job.

     

v-sdhruv's avatar
v-sdhruv
Icon for Community Support rankCommunity Support
1 year ago

Hi @Jerome22 ,
Hope you were able to get some clarity on the issue. 
If any of the responses has addressed your query, kindly mark it as accepted solution so that the other members can find it easily.
Thank you