I have Data is on the storage account(50+ CSV files)- loading to Azure SQL. If there is no change in files all the load works fine. If I add an extra column to CSV files, these are new columns and are not present in the first load. What do I need to do?
Pipeline:
Get metadata - for each loop used to load the data.
PS: this should be implemented in ADF only.
If you can please give me some guidelines that will be great.
or upvote
button whenever the information provided helps you.