Incremental sync successful but rows in nested table are Duplicated

I’m trying to sync a stream with nested array data but the final table isn’t dedup.

Basic normalization doesn’t apply de-dedup in nested data.
See issue Destination MSSQL duplicate array records when using incremental append (nested tables) · Issue #9465 · airbytehq/airbyte · GitHub

As a workaround you can export the dbt project built by Airbyte and edit the nested table generation doing the dedup.