ADF Copy - Data type conversion - Mapping section grayed out

Santosh Durai 21 Reputation points
2021-03-24T02:39:47.693+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,296 questions
No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 37,766 Reputation points
    2021-03-24T06:03:57.24+00:00

    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


0 additional answers

Sort by: Most helpful