We use dbt for deduplication, so the destinations that directly integrate with dbt support the incremental - deduped sync mode. Here is the list of destinations that support it:
- MySQL
- Postgres
- Snowflake
- Redshift
- BigQuery
- Oracle
Learn more about the Incremental - Deduped sync mode here.