I am trying to load CSV files from an AZURE Blog storage to AZURE SQL via ADF Copy activity. My intention is to use Auto Create to create the target SQL table.
As the column meta data for the CSV file is string, I wanted to use the mapping section to change the data types to the relevant ones. I imported the schema definition , however the Data type section is grayed out and does not let me to change it. Am I missing something? It will be great some one could help me.