Auto Table -- Table created with nvarchar datatypes

M, Murugeswari (Cognizant) 456 Reputation points
2022-03-30T07:50:24.637+00:00

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....

188284-image.png

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.
10,845 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pratik Somaiya 4,206 Reputation points
    2022-03-30T10:26:29.507+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.