can we automatically Create table in azure usind data factory and enter data from our csv file

Question

i have huge csv file with around 100 columns i dont want to create table in db manually can i create pipeline in azure data factory to create a table and insert data into it using csv file

Answer 1

Hi @Shivang Singh

Yes. You can create table on the fly in the copy activity or data flow. Auto create table option in the sink helps create a table by the name you specify on the sink data set.

You may kindly check the below video for reference to use copy activity for creating tables on the fly during pipeline execution.-

https://youtu.be/JapauRIKjSQ?si=ORn26hv7V0Bc-yp6

Please check and revert in case you have any queries

Thank you.