[Feature][Connector] Implement multi-table sink support for connectors

[davidzollo]

Description

Based on the tracking issue #5652 and codebase analysis, many sink connectors still lack support for the SupportMultiTableSink interface. We are looking for contributors to help implement this feature for the remaining connectors.

Implementing SupportMultiTableSink allows the connector to handle multiple tables in a single sink instance, which is crucial for database synchronization scenarios (e.g., CDC).

Connectors to be implemented

Type	Connector	Contributer	Status	PR
Sink	AmazonDynamodb	@Best2Two	Doing
Sink	Cassandra		Todo
Sink	DingTalk		Todo
Sink	Feishu		Todo
Sink	GoogleFirestore		Todo
Sink	IoTDB		Todo
Sink	Neo4j		Todo
Sink	Pulsar	@Muktha9491	Doing
Sink	RabbitMQ		Todo
Sink	Rocketmq		Todo
Sink	S3Redshift		Todo
Sink	SelectDBCloud		Todo
Sink	Sentry		Todo
Sink	Slack		Todo
Sink	Socket	@AshharAhmadKhan	Doing
Sink	Tablestore		Todo
Sink	Kafka	@misi1987107	Doing	#10154

How to Contribute

1. Pick a connector: Choose one from the list above.
2. Claim the task: Comment on this issue (e.g., "I would like to work on AmazonDynamodb").
3. Implement:
   • Modify the Sink class to implement the org.apache.seatunnel.api.sink.SupportMultiTableSink interface.
   • Update the SinkFactory to handle CatalogTables correctly.
   • Ensure tables_configs or equivalent logic is handled if necessary (though Sink usually relies on the upstream CatalogTable).
4. Reference:
   • You can refer to the implementation of JdbcSink or ElasticsearchSink.
5. Submit PR: Submit a Pull Request and link it to this issue.

Thank you for your contribution!
Please leave a message if you‘d like to implement the multi - table sink feature for any connector.

[AshharAhmadKhan]

hi @davidzollo
I'd like to work on the Socket connector. I have experience with Java and have reviewed the JdbcSink implementation. Can you assign this to me?

[Best2Two]

Hi @davidzollo
I would like to work on AmazonDynamodb, I have a very good experience in some java-like programming languages that uses OOP paradigm, also I have a good expereience with AWS.

[davidzollo]

If you'd like to implement these connector features, please leave a related message like I'd like to implement XX multi-table sink and then you can submit your PR within four weeks.

A very kindly reminder: Other guys can pick it up if the related PR is not submitted within four weeks. ^-^

Here are some helpful resources to get started:

• Contribution Setup Guide
• Code Submission Guide

By the way, since this might be your first contribution, I think we can have a more in-depth communication to help you get familiar with SeaTunnel. Feel free to contact me on LinkedIn (David Zollo) . When adding me, please let me know your GitHub ID. I'd be happy to assist you!

[AshharAhmadKhan]

Hi @davidzollo,
I’ve submitted a PR for the Socket connector: #10432, which implements multi-table sink support.
I’m happy to address any feedback or follow up with improvements if needed.
Thanks!

[Best2Two]

Hi @davidzollo I guess there is an issue in the first link regarding Contribution Setup Guide it shows 404 page

[dybyte]

Hi @davidzollo I guess there is an issue in the first link regarding Contribution Setup Guide it shows 404 page

Thanks for pointing that out! I found the setup guide in the official documentation here: https://seatunnel.apache.org/docs/developer/setup