ADF Copy - Data type conversion - Mapping section grayed out

Question

Hi,

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.

Thank you,
Santosh

Answer 1

Auto create table option will create table with default data types. You will have to alter the table later and modify data types as required.

If you are concerned about table definition, better to create the table in advance.

See similar question - https://stackoverflow.com/questions/61240726/why-the-default-auto-created-sql-tables-column-length-is-1-in-azure-data-factor

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav