Hey, team. I'm testing AirByte for PG > RedShift sync (CDC, wall2json). both source and target work perfectly.
created a connection and mapped 2 tables with "Incremental | Deduped + History" method. primary key = 1 int field in PG
• first sync goes well
• if I modify record on source side - see new record appearing in ***_sdc table
• record in destination table gets updated
• new record in source - also goes through
BUT
• when delete in source
• after sync see deletion record in ***_sdc table in destination
• but record in destination table just remains. even after 2-3 syncs.
what might be wrong? why deletion event reaches SDC table in destination, but not applied to destination table itself? thanks in advance for your help