Move File rather than copy in Azure Data factory

Debbie Edwards 521 Reputation points
2020-08-03T09:49:05.573+00:00

In Data Factory you can copy a file but Im thinking, is data factory the best thing to use if you are going to move a file from one area to another?

Is Logic Apps a better solution to go for if you are going to simply move a file?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,875 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,663 questions
0 comments No comments
{count} votes

Accepted answer
  1. HarithaMaddi-MSFT 10,136 Reputation points
    2020-08-03T12:17:59.943+00:00

    Hi @DebbieEdwards-1726,

    Welcome to Microsoft Q&A Platform.

    With the delete activity in Azure data factory, this can be added to copy activity and once file is copied, it can be deleted from source. The same can be achieved in Logic App using a trigger. The option to use depends on use case. If it is simply moving a file without any transformations, loading and reporting of the data in it and it needs to be automated, logic app would be good to use.

    Hope this helps! Do let us know for further questions.

    1 person found this answer helpful.

6 additional answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,631 Reputation points
    2020-08-03T19:07:46.207+00:00

    You could see "Delete files after completion" setting in Copy activity in ADF. This way, files will be moved to target.

    15148-image.png

    ===============================================

    If the response helped, do "Accept Answer" and upvote it -- Vaibhav

    2 people found this answer helpful.

  2. Gieger, Alfred 141 Reputation points
    2021-05-21T07:35:01.377+00:00

    I fully agree. This should be a standard activity in ADF. Not only because of the timestamp, but also because you could move folders within milliseconds instead of within hours.
    But I have seen solutions arould using Azure Functions doing so. Those can be triggered out of ADF.
    To be honest, I have not tried that so far, because I have shifted my focus to Databricks, which is much better suited for transforming our data. There I can use python libraries to move files.

    1 person found this answer helpful.
    0 comments No comments

  3. Johan Lindell 6 Reputation points
    2021-07-19T10:31:34.61+00:00

    It's kinda insane that a simple operation like this doesn't exist in ADF in 2021.

    1 person found this answer helpful.
    0 comments No comments

  4. bitsofinfo 1 Reputation point
    2021-04-15T21:37:16.95+00:00

    i don't see this "delete files" option in ADF, for any of the "file path types"

    0 comments No comments