Forum Discussion
Super UserCopy Job OVERWRITE
Hi ToddChitt,
Microsoft got back to me via teams and this is by design.
Poor design, but design nonetheless.
I have voted for your idea: Copy Job needs more functionality - Microsoft Fabric Community
to have this added.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Super UserHi ToddChitt,
This is an interesting find, I'm pretty sure I have a copy job that is overwriting data in a warehouse, not just appending data.... I hope..... I will look at this tomorrow morning.
If this is the case that it only appends, this is a pretty major lack in featureset here.
One workaround that immediately comes to mind is to use a pipeline, first have a script task to truncate the table, then run the copy job from the pipeline - though at this point you might as well just use a copy activity in the pipeline and skip the copy job all together.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.