Hi all, we’re experiencing an onboarding blocker. We’re trying to set up a MySQL db as a source, and BQ as a destination. However, our MySQL DATETIME fields are getting imported as strings into BigQuery. This is not ideal, because we require date fields for our BI tool.
It appears that the MySQL connector designed to import dates as strings, looking at the docs: https://docs.airbyte.com/integrations/sources/mysql/#data-type-mapping
However, Big Query appears to support importing a date field: https://docs.airbyte.com/integrations/destinations/bigquery/#data-type-map
How do we import date types into BQ?
h
Harshith (Airbyte)
08/08/2022, 10:04 AM
Hey could you check the type in the connection settings page? Kindly request you to post it here https://discuss.airbyte.io/ for more assistance