Is it possible to trigger an Azure Data Factory Pipeline when a file is deleted from BLOB storage

Jay 561 Reputation points
2021-03-01T09:47:25.937+00:00

I'm going to have a pipeline which selects data from an on prem sql server db, into csv file and then to Blob and then to Share Point (no ADF connector to SharePoint).

I don't want it running every 5mins on a schedule, sometimes it may run 20 times in a day and other times only 1 time in a week.

The users decide when they need to file created.

Is it possible for a user to manually trigger an Azure Data Factory Pipeline?
or other option
Is it possible to trigger an Azure Data Factory Pipeline when a user removes the current file from BLOB storage?

Trying to workout how best to do this...

Thanks,
J

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,575 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,721 Reputation points
    2021-03-01T09:53:49.057+00:00

    You can try having Event based trigger which will trigger the pipeline as soon as blob/file is deleted from your storage account.

    Refer the screenshot in step 7 in this document - https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-event-trigger

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.