Ignacio Valdelvira
08/01/2022, 10:36 AMorders 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!