bit data type is casted as string and results in an error

[BamboOSZ]

The data source I'm using contains a couple of columns of a bit(1) type (yeah, they could have used boolean instead).
Anyway, when I run tap-mysql against it I receive the following error:

2024-03-28T16:34:30.935510Z [info     ]     raise error                cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.936500Z [info     ] jsonschema.exceptions.ValidationError: 1 is not of type 'string', 'null' cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.936500Z [info     ]                                cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.937503Z [info     ] Failed validating 'type' in schema['properties']['IsForLookup']: cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.937503Z [info     ]     {'type': ['string', 'null']} cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.937503Z [info     ]                                cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.937503Z [info     ] On instance['IsForLookup']:    cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2024-03-28T16:34:30.938500Z [info     ]     1                          cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake

Looks like it's incorrectly mapped as string. Can this be fixed?

[visch]

Definietly fixable, easy one is you should be able to override the schema and specify that this is an integer and you'd be good to go.

Fix would be here https://github.com/MeltanoLabs/tap-mysql/blob/main/tap_mysql/client.py#L174 need a mapping for bit. We should also take target-postgres's lead here https://github.com/MeltanoLabs/target-postgres?tab=readme-ov-file#data-types and do a mapping of data types to be sure we didn't miss anything else obvious like this!