question

ShambhuRai-4099 avatar image
0 Votes"
ShambhuRai-4099 asked AnnuKumari-MSFT commented

csv to csv data load in adf

Hi Expert,

how to load data from csv o csv using ADF nusing copy transformation or any readymade component

azure-data-factoryazure-databricksazure-data-lake-storage
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

AnnuKumari-MSFT avatar image
1 Vote"
AnnuKumari-MSFT answered AnnuKumari-MSFT commented

Hi @ShambhuRai-4099 ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query.
As I understand your question, you want to copy data from one ADLS location to another and source and sink both are of csv format. Please let me know if my understanding about your query is not clear.

Here are the steps you need to follow to achieve the above requirement:

Open Azure data factory workspace and perform the following steps:

  1. Create dataset with type- Azure datalake gen2 and select csv format. Browse the location and select the input file which you want to copy. This will act as the source dataset.

  2. Create another dataset with type -Azure datalake gen2 and select csv format. Provide the foldername and filename in which you want to store the data. If the output folder is not existing already, ADF will create the folder during the runtime.

  3. Use copy data activity in ADF pipeline and select first dataset as Source and second dataset as Sink and debug the pipeline.

Here is a video which you can refer for better understanding : https://www.youtube.com/watch?v=XOJeyRBXBos

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


· 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.

Hi @ShambhuRai-4099 ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

0 Votes 0 ·