How to Automatically Convert MySQL datetime to BigQuery timestamp in Airbyte?

[duongdr]

Hi team,
I am using Airbyte to sync data from MySQL to BigQuery. I need the MySQL datetime fields to be automatically converted to timestamp fields in BigQuery. Currently, the datetime fields are not converting correctly, and I would like to know the best way to handle this transformation.
Is there a way to configure Airbyte to perform this conversion during the sync process?
Thanks!