how to load data from csv o csv using ADF nusing copy transformation or any readymade component
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:
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.
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.
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 or upvote 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
12 people are following this question.