all-things-risingwave
Is there a way to reuse JDBC connection params across multiple Postgres sinks in RisingWave?
Joe Lind is looking for a way to reuse JDBC connection params across multiple sinks in RisingWave, similar to how shared sources work for the Postgres source.
Jo
Joe Lind
Asked on Mar 04, 2024
- In RisingWave, the shared CDC source allows tables from the same database to come from one source, but for sinks, each
create sink
statement needs to go to a specific table. - Parameters like
primary_key
andtype
cannot be shared across multiple sinks. - The only shareable parameter is
jdbc.url
, so currently, RisingWave does not support sharing a connection for multiple sinks. - If you have a specific use case where you need to share JDBC connection params across multiple sinks, you can provide more details to the team for consideration.
Mar 05, 2024Edited by