Hello all,
TL;DR - With regard to the MySQL connector, if I use CDC to capture incremental changes, will I have an issue with tables that don’t have changes within a certain period of time (e.g. table A doesn’t have a change within 7 days but the binary logs get removed after 7 days). Put another way, does CDC update the binary log reference when I sync even if the table does not have any updates?
I’m new to Airbyte and looking to sync MySQL data to Snowflake. I’m actually coming from the Meltano framework so familiar with some concepts of data integration. One thing that I discovered in the underlying code for that framework is that binary log replication will only update the state when the table has a change. That is to say, if I have a table that updates very infrequently, the binary log of the last update to that table may get removed before a binary log has a new transaction. I thought I was keeping things fresh by updating everyday but have found out the hard way that many of my tables can no longer sync because the referenced binary log is now missing. I’m not sure if this is a requirement of binary log replication OR this is based on the underlying singer tap that I was using.
So before I truly get started in this Airbyte, I’d like to understand if CDC incremental updates will refresh the referenced log even if the table doesn’t have any changes.
Thanks all.