MySQL v8.0 to Clickhouse Incremental | Deduped + History sync error

Hi @alafanechere,
When you said the Total records read: 0 (0 bytes) I suspect maybe I didn’t enough permissions for the CDC to the user I created in MySQL 8.0 instance. I ran this statement and the problem is now resolved. I didn’t think I forgot to give enough permissions for that instance.

GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'airbyte'@'%';

Thanks a lot for you guidance and help. We can close this ticket.

1 Like