Forum Discussion
Jerome22
Resolver I
Resolver Iupdating 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.
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.
smeetsh
Continued Contributor
Continued ContributorWe often do a clear out of tables or certain rows in tables, but we have a few datasets that are so large that is slows things down.
This can de done with just pipeline activities (copy and script activity), notebooks are not always needed. I would only use a notebook when i need to do something with a lakehouse.