I would like to request Fivetran to consider the Primary Key at the destination upon creation, thus preventing record duplication.

Reference case: #201286 : Fivetran Support <> Exxon Mobil Team - SQL Server Duplicates