JDBCAppendTableSink on Data stream

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

JDBCAppendTableSink on Data stream

chiggi_dev
Hi,

In the documentation, the JDBC sink is mentioned as a source on Table API/stream. 

Can I use the same sink with a Data stream as well?

My use case is to read the data from Kafka and send the data to Postgres.

I was also hoping to achieve Exactly-Once since these will mainly be Idempotent writes on a table.

Any help much appreciated. 

Thanks,

Chirag
Reply | Threaded
Open this post in threaded view
|

Re: JDBCAppendTableSink on Data stream

Stefan Richter-3
Hi,

That should be no problem, for example the `JDBCAppendTableSinkTest` is using it also with data stream.

Best,
Stefan

On 6. Feb 2019, at 07:29, Chirag Dewan <[hidden email]> wrote:

Hi,

In the documentation, the JDBC sink is mentioned as a source on Table API/stream. 

Can I use the same sink with a Data stream as well?

My use case is to read the data from Kafka and send the data to Postgres.

I was also hoping to achieve Exactly-Once since these will mainly be Idempotent writes on a table.

Any help much appreciated. 

Thanks,

Chirag