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

Copper Contributor

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

 

0 Replies