[destination-bigquery] timestamps ignore timezone

[andrea-zanetti]

Connector Name

destination-bigquery

Connector Version

2.8.9

What step the error happened?

During the sync

Relevant information

While trying to replicate tables from a MySql server with CET/CEST timezone (we have correctly configured MysqlSource jdbc parameter timezone=Europe/Rome) all timestamp values are inserted as UTC timestamp without conversion, i.e.

[Original value] 2014-06-27 15:55:00.000000
[Inserted value] 2014-06-27 15:55:00.000000 UTC
[Expected value] 2014-06-27 13:55:00.000000 UTC

This bug is very similar to this old one: Destination BigQuery Denormalized : lose timezone after insert datetime with TZ

Relevant log output

No response

Contribute

• Yes, I want to contribute

[andrea-zanetti]

We realized the problem is in the source so i'm closing the issue.