apache/seatunnel

[Feature][Connector-V2] Source/Sink support read/write TIMESTAMP_TZ

Open

#9785 opened on Aug 28, 2025

View on GitHub
 (6 comments) (0 reactions) (0 assignees)Java (6,897 stars) (1,432 forks)batch import
featurehelp wanted

Description

Search before asking

  • I had searched in the feature and found no similar feature requirement.

Description

After #8367 and #9784 . We support transform timestamp with time zone in sql transform and write into jdbc sink.

We should support read timestamp with time zone type from all source which support this type. And write into all sink which support this type.

This is a ticket that tracks all sources and sinks. However, you can have one PR address the functionality of one connector at a time.

Usage Scenario

No response

Related issues

No response

Are you willing to submit a PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Contributor guide

Tech stack
javasql
Domain
datadatabase
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
JavaSeaTunnel connector APISQL timestamp typesJDBC
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60
Research direction
This is a tracking issue for adding TIMESTAMP TZ support to all source/sink connectors. Reference previous PRs #8367 and #9784 for examples in SQL transform and JDBC sink. Start by selecting one connector (e.g., JDBC source) and examine its current type mapping. Look at the connector's reader/writer interface and see how TIMESTAMP is handled. Implement support for TIMESTAMP TZ by adding the type to the mapping and ensuring proper serialization/deserialization. Check existing tests for guidance.