Hi All, I am sourcing from Postgres and am having a challenge with the date types being transferred to my destination MS SQL and Postgres. The dates transfer as strings. Here are the field definitions: • Postgres Source: created_at timestamp with time zone NOT NULL DEFAULT now(), • Postgres Destination: created_at character varying COLLATE pg_catalog."default" • MS MSQL Server Destination: [created_at] [varchar](max) NULL, Any guidance is appreciated. Thanks.

loading...

log file of sync

This is a current limitation of Airbyte: https://github.com/airbytehq/airbyte/issues/8280 so Airbyte will transfer as a string. If you want to you can add a custom dbt and transform to what format you prefer, but Airbyte needs to keep working to all data types o any destination.

Thank you @Marcos Marx (Airbyte)