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.