BlobEventsTrigger could not be fired if the Blob file is updated via sftp

Shao Peng Sun 81 Reputation points

I created a BlobEventsTrigger in Synapse to trigger one of my pipeline.
If the file is uploaded via Azure Storage Explorer or curl, then the trigger could be fired and works fine.
But if the file is loaded via sftp command, then the trigger could not be fired.

Could you please help to understand why could this happen and how could make it work with SFTP approach?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,096 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Nandan Hegde 22,721 Reputation points

  2. KranthiPakala-MSFT 38,597 Reputation points Microsoft Employee

    Hello @Shao Peng Sun ,

    Thanks for the question and using MS Q&A platform.

    As @Nandan Hegde , pointed, please refer to above thread link where a similar issue has been discussed.

    In order to make it work, please added SFTPCommit to the AdvanceFilters on the EventGrid SystemTopic thats auto generagted when the trigger is created from datafactory for the storage account.

    SFTPCommit should be added as you need the trigger to start when the file is completely loaded on the sftp container.

    I'm working with internal team, to see if there is scope to improve the product or to clarify this in public documentation. Will keep you posted as soon as we have an update.

    But in the meantime, as a workaround, you can follow the above process to mitigate the issue.


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


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how