question

LiuVeronicaSiqi-2329 avatar image
0 Votes"
LiuVeronicaSiqi-2329 asked LiuVeronicaSiqi-2329 commented

Can we copy data from SQL server to AWS S3 by using Azure Data Factory?

As I know, we can take AWS S3 as a source data in Azure Data Factory.
But I want to know if we can take AWS S3 as a target in Azure Data Factory?

e.g:

I get the source data from SQL Server by using Azure Data Factory, and now I want to copy the data to AWS S3.

Can I do it as the above ?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered LiuVeronicaSiqi-2329 commented

Hello @LiuVeronicaSiqi-2329,

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

Unfortunately, Azure Data Factory does not support AWS S3 as sink.

201238-image.png

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Workaround: You can use custom activity/azure function to write back to S3 for now.

For more details, refer to below links:

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

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators


image.png (7.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks a lot for your answer, it helps!

1 Vote 1 ·