Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-7022

Add timezone conversion to metadata in Timezone Converter SMT

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 2.6.0.Alpha2
    • None
    • core-library
    • 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'.

              anmohant Anisha Mohanty
              jakobhaggstrom Jakob Häggström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: