Synapse Copy Data from SQL to Data Lake, need to over write file each day

Question

I am using the copy data task in Synapse to copy the result of a procedure to a csv file. I want to overwrite the file with each run, but I don't see an option. Is there one? Is there a work around? Any link or help appreciated.

Mike

Answer 1

Hi @Computer Mike ,
Thankyou for using Microsoft Q&A platform and posting your query.
As I understand your query, the ask is to overwrite the file every time it gets copied. Could you please share the screenshot of your sink dataset for us to understand if the file name and path is static or dynamic?

If you use the same file path and file name every time you perform the copy , it is the default behavior that the file would be overwritten.

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

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

• Please don't forget to click on or upvote button 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