Postgresql – Azure Data Factory set DateTimeOffset data type for auto-created table in Copy activity
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…