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

Copper Contributor

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

when I auto-create table in Azure SQL it always creates datetime2(0) and looks like

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