Hi All, in

hubspot

connection we are enable

deals

streams with

incremental | deduped history

sync mode, but in deals_properties contains duplicate row, is there any solution get rid of duplicates without modifying DBT script or changing sync mode.

The similar issue was reported in Github for the companies stream. https://github.com/airbytehq/airbyte/issues/19207 This happens because properties is a nested table generated by normalization. The issue to solve this problem is https://github.com/airbytehq/airbyte/issues/9465. Today there isn't any solution to fix wihtout editing the dbt module

Thank you @Marcos Marx (Airbyte)