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 and type 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