Auto Table -- Table created with nvarchar datatypes

M, Murugeswari (Cognizant) 451 Reputation points

We have a task to migrate tables from on-premise oracle to Blob (stage) first and then finally to synapse via ADF. While copy from blob to kumo --In the sink, we enabled the "Auto Table" feature

After loading, when we checked in the Synapse could see all datatypes are nvarchar. But in the source we have different datatypes for various columns including decimal, integer....


But when we migrate directly from oracle to synapse (without blob stage), could see data types are retained as such.. Only if we migrate from blob (file format) to Synapse, getting nvarchar datatypes for all the columns

Is it possible to retain the same datatype for the corresponding columns while copying to synapse from blob [ file format]

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

Accepted answer
  1. Pratik Somaiya 4,126 Reputation points

    Hello @Anonymous

    What is the type of file, is it CSV or Parquet?

    While loading data from Oracle to Azure, the data type is bound to change as mentioned here

    To retain the data type you will have to provide mapping in the Copy Activity for that you need to have table present already in Synapse

    Please refer a similar article here

0 additional answers

Sort by: Most helpful