We were faced with a problem when we were using MySql Source Connector.
In our source, we have a column with type tinyint(1), but it doesn’t mean that values are limited to 0/1. Those values can be in the range of 0…9, but Airbyte’s MySql Connector casts them to boolean (MySQL | Airbyte Documentation)
@leeco and @coca-alex you can change the connector to work without using the default behavior of Airbyte. Today Airbyte handle this as described in MySQL documentation, maybe in the future can be changed to another way.