Hi, I tried to sync the table with Incremental | Deduped + history mode in Airbyte and the issue is when I deleted some records in the source(MSSQL Server), the table in the destination(Big Query) doesn't seem to remove those records,
I already enable CDC btw. issue only occur in deduped table, not in history table which has "_scd" in suffix.
It works fine with update transaction.