Summary
The user is facing issues selecting an incremental sync mode for MySQL to Snowflake connector, suspecting it’s due to the lack of a primary key in the table. They are also unsure how to mark a compound primary key in the schema.
Question
Hello! Im using airbyte mysql > snowflake. The connection is set to read from the binlog, but I cannot select an incremental sync mode. The table has no primary key, and im suspecting that is the reason its forced to do a full refresh, but im confused as to why. Shouldnt the binlog have timestamps that could be used as a cursor?
The way we treat our mysql table is that two columns are a compound primary key. But i dont see a way to mark that in the schema.
we are on airbyte 0.63.2
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.