[destination-mysql] MySQL connector does not transform timestamp

[AlexandrosCM39]

Hi there!

I am new in Airbyte and I have some "issues".

I am trying to replicate data from MySQL to another MySQL as CDC (using binlogs). All replication has been great except for the timestamps fields.

Timestamp[withTimezone] fields information are not being correctly transformed in the destination database.

In airbyte_internal raw data the value is like

In the final table the value stills as varchar.

Is there an issue about this? Is there something I need to configure for these values to be converted to timestamps correctly? Is there any workaround to solve this?

Thank you!

[Source]
Connector Name source-mysql
Connector Version 3.4.9

[Destination]
Connector Name destination-mysql
Connector Version 1.0.0

[System]
Airbyte version 0.58.1