Re-attempt adding duplicate raw data

I am using airtbyte to fetch data from hubspot, it should fetch 3 rows of raw data. But due to some scope issues, workflow gets partially completed and re-attempts again. After 3 re-attempts (and partial successful execution), I’ve 9 rows of raw data (3 duplicates of each row for each attempt). Is there any way to resolve this? It works fine if I remove the specific data for which the token doesn’t have permission. Workflow gets completed and I get 3 rows.

@[DEPRECATED] Marcos Marx turned this message into Zendesk ticket 2648 to ensure timely resolution!

Are you using incremental+dedup mode or what mode are you using?

Yes.

Normalization should remove the duplicate records for your final tables. Duplicates are expected in the raw tables.

But if the query gets executed correctly in the first attempt and I manually sync again after few minutes, it only fetches the latest data (raw). No dups. Is this also expected behaviour?