Hi all, is it possible for CDC in Postgres to miss...
# advice-data-ingestion
i
Hi all, is it possible for CDC in Postgres to miss some record updates? I have an
orders
table with a
state
field that changes every time the order moves state and a
cdc_updated_at
field used as a cursor to detect changes in the table. I’ve identified an order that has a different
state
in my origin DB and my destination data warehouse. The order’s state was updated one month ago but somehow it wasn’t picked up by Airbyte. I’ve compared with other orders and all of the ones I checked are being updated properly It’s a question difficult to answer because I can’t find any logs on the job in order to identify the issue but just wondering if someone has come across with something similar!