If you've noticed that some MySQL
TINYINT(1) columns are displaying as
BIT in Stitch, it's usually due to how the MySQL driver converts this data type.
boolean are synonymous. Because of this, the driver implicitly converts the
TINYINT(1) fields to boolean if the the Java
tinyInt1isBit configuration property is set to
true (which is the default) and the storage size is 1. Stitch then interprets these columns as
For more info, refer to MySQL's Java and MySQL Types documentation.
To work around this, you have a few options:
boolean, such as
TINYINT(4)or the data type you choose. The view can then be set up to be replicated through Stitch.