Hey all, is there a way to force Airbyte to specif...
# ask-community-for-troubleshooting
j
Hey all, is there a way to force Airbyte to specify the field type on connections? I'm syncing from MySQL to BigQuery, but its using a
string
for the
created_at
field, even though its a
timestamp
in mysql
1
Just seen this: https://docs.airbyte.com/integrations/sources/mysql#data-type-mapping. Why are
datetime
and
timestamp
columns converted to string? Seems weird ...
Ah, looks to be something with this
m
Airbyte has some limitation converting data, and MySQL has some complexity dealing with datetimes too. The best way to to Airbyte handle this for now is converting to string and you can execute a post-operation converting to the correct data type you want in your destination.
1