Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

az_38's avatar
az_38
Copper Contributor
Jul 03, 2023

Azure Data Factory set DateTimeOffset data type for auto-created table in Copy activity

Hi,
I copy data from postgre db to azure sql with copy activity and auto-create table feature enabled.

there is a column with type timestamptz in Source db. looks like
2023-07-03T07:00:47.707369+00:00
2023-07-03T07:00:52.375166+00:00

when I auto-create table in Azure SQL it always creates datetime2(0) and looks like
2023-07-03T07:00:47
2023-07-03T07:00:52


I want to create sql datetimoffset column. I tried mapping but not succesfully
If I do copy in existing table with datetimoffset colum - everything works correct, the problem only appears when table is created by adf engine

 

No RepliesBe the first to reply

Resources