Handling numeric and date data conversion issue in Airbyte


Airbyte user facing issues with numeric and date data conversion to string(text) when synchronizing data from Google Sheets to MySQL. Looking for a solution to handle this problem.


Hi everyone. I have installed airbyte, mysql, metabase on our internal server. I use airbyte to synchronize data from google sheets to mysql but I have problems with numeric and date data, when entering mysql it is changed to string(text). I can’t configure airbyte to change that. I switched to using csv and excel files as input sources and was able to convert numeric data into mysql. However, date data is still string(text). Please help me see if there is any way or solution to handle this problem? Thank you very much.

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["airbyte", "google-sheets", "mysql", "data-synchronization", "numeric-data", "date-data", "conversion-issue"]