Setting up datetime format between MySQL table and Parquet file in Airbyte

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

Airbyte is detecting datetime fields from MySQL table but displaying them as [object Object] in the Parquet file. How to correctly set up the datetime format?


Question

Hello there, I am currently setting up a flow between a MySQL table to a Parquet file. In my table, I have few fields as ‘datetime’ like 2023-08-08 14:00:54. In my parquet file, I end up with [object Object]. Airbyte detects the Datetime but gives me this data. How can I set up the format correctly ?


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

["mysql-table", "parquet-file", "datetime-format", "airbyte-connector"]
2

I tried to downgrade the source and destination connector but I still have this weird field. Did anyone faced this issue ?