I’m using Stitch to extract data from a Heroku Postgresql follower database into Snowflake. I’m using a timestamp column updated_at as the replication key. I’ve noticed there are missing updates and inserts (changes in source not propagated) in my destination tables. It does not impact all tables. Sometimes it happens on consecutive days, sometimes intermittently. I’ve already contacted Support and they suggested that I’m having race conditions and as a workaround I need to set my replication frequency every minute. I’ve tried that fix and still I’m having missing updates. Anyone here who have encountered this issue? How did you solve it?
Thanks so much in advance.