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]