Configured server timezone for the MySQL source ignored during sync

[Samnitium]

Connector Name

source-mysql

Connector Version

3.10.1

What step the error happened?

During the sync

Relevant information

When trying to replicate tables from a MySql server with CET/CEST timezone, values ​​with Timestamp data type are inserted as UTC timestamps without any conversion:

Value from MySql table:
2025-01-29 16:30:00.000000

Value insert into BigQuery:
2025-01-29 16:30:00.000000 UTC

Expected value in BigQuery:
2025-01-29 15:30:00.000000 UTC

More information:
• Configured server timezone for the MySQL source (Advanced): Europe/Rome
• I'm using as destination "destination-bigquery" version 2.9.2

Relevant log output

Contribute

• Yes, I want to contribute