Forum Discussion
az_38
Jul 03, 2023Copper Contributor
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