topic Copy activity SFTP is triggering twice on file create event in Data Engineering

Copy activity SFTP is triggering twice on file create event

P_work — Wed, 02 Jul 2025 14:02:42 GMT

A trigger that is set to trigger when a file is created in the Lakehouse triggers twice when the file is create with Copy SFTP activity. What would be needed to have trigger fire once? Note, uploading a file works as expected.

Re: Copy activity SFTP is triggering twice on file create event

v-venuppu — Thu, 03 Jul 2025 12:25:02 GMT

Hi P_work ,

Thank you for reaching out to Microsoft Fabric Community.

Your trigger fires twice because the Copy activity creates temp files first, then renames them. each counts as a "file created" event.

Set the trigger to fire only on final files by:

1. Filtering by file extension (e.g., .csv, not .tmp)

2. Copy to a staging folder, then move the completed file to the monitored folder.

This ensures the trigger fires only once per actual file.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

Re: Copy activity SFTP is triggering twice on file create event

P_work — Thu, 03 Jul 2025 13:16:05 GMT

I will try the solutions, as the staging folder sounds feasible. However, the event details of the trigger show the subject to be the filename duplicated, not a .tmp file. Option 2 still holds promise.

Re: Copy activity SFTP is triggering twice on file create event

v-venuppu — Fri, 04 Jul 2025 05:16:06 GMT

Hi P_work ,

Thank you for your Response. Please let us know if you have any further issues?

Thank you.

Re: Copy activity SFTP is triggering twice on file create event

v-venuppu — Mon, 07 Jul 2025 09:10:32 GMT

Hi P_work ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

Re: Copy activity SFTP is triggering twice on file create event

P_work — Mon, 07 Jul 2025 12:22:05 GMT

Option 2 worked as expected.