How to download a File from blob storage to Local system with help of Azure Data factory?

Question

Kumar, Himanshu 0

We have an AZURE SFTP setup to load files in Blob storage. These files size ranges from 300 MB to up to 20gb

We do want to see if there is an option to use ADF to download the files to local system.

We have our application deployed in Azure platforms using .net.

Kindly Suggest

Anand Prakash Yadav 7,875 Reputation points Microsoft External Staff

2024-01-05T09:35:49.43+00:00

Just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Anand Prakash Yadav 7,875 Reputation points Microsoft External Staff

2024-01-05T09:36:30.8933333+00:00

Just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Anand Prakash Yadav 7,875 Reputation points Microsoft External Staff

2024-01-08T13:08:11.0133333+00:00

Just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Anand Prakash Yadav 7,875 Reputation points Microsoft External Staff

2024-01-05T09:35:49.43+00:00

Just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Anand Prakash Yadav 7,875 Reputation points Microsoft External Staff

2024-01-05T09:36:30.8933333+00:00

Just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Anand Prakash Yadav 7,875 Reputation points Microsoft External Staff

2024-01-08T13:08:11.0133333+00:00

Just checking in to see if the below-answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,796 MVP Volunteer Moderator

Hey,

you can use Copy activity to copy files from Source : Azure Blob storage to Sink : File System wherein you can download files to the local .

Note: the integration runtime needs to be installed on that local system

Kumar, Himanshu 0 Reputation points

2024-01-03T07:28:38.3166667+00:00

Thanks Nandan.. let me try this and revert if this works for us...
Kumar, Himanshu 0 Reputation points

2024-01-03T08:06:08.3333333+00:00

The thing is we have the Source as a private endpoint in Azure network and Sink needs to be as public endpoint for the user to download files. They may not have access to the file systems to download the file directly.

Anything you can suggest once lets say after the file is copied to that location.