copying data from azure file share to synapse

Rohit Boddu 461 Reputation points
2020-11-04T07:49:56.757+00:00

Hi ,

I have one requirement like -

1)my users will load some data to azure file share that is mounted on there machine

2) now i want to copy that data from azure file share to container in storage account

3)from that container i want to serve data to synapse/copy data to synapse

Please tell me for solution on this requirement and how to implement solution as well.

Regards,
Rohiit

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,360 questions
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.
4,431 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2020-11-04T22:04:25.083+00:00

    Hello @Rohit Boddu ,
    Thank for the ask and good to be in touch again :)
    You can use Azure dafactory as it supports Azure file share . Please see the animation below and its should help . The way i think we can solve the issue is by using one copy activity to copy the file from file share to the storage and then one more copy activity from storage to Synapse ( not part of the below animation ) .

    37519-123-18.png

    37546-filreshare.gif

    Let me know if you have any questions .

    Thanks Himanshu

    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.