-
Enhancement
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
None
-
False
Feature request or enhancement
For feature requests or enhancements, provide this information, please:
Which use case/requirement will be addressed by the proposed feature?
We aim to utilize the timestamp provided in the metadata to track when changes occurred in the source. However, the Debezium JVM process operates in a different timezone than the source, resulting in a mismatch between timezones. This discrepancy occurs because the timestamp fields 'ts_ms' and 'source.ts_ms' are set by the internal clock of Debezium, rather than the source. While it is possible to convert timestamps using the Timezone Converter SMT, this SMT only converts fields in the 'before' and 'after' sections. Therefore, we propose extending this module to also convert timestamp fields in the metadata, such as 'source.ts_ms'.