ClickHouse sink #552

Answered by pashagolub

ondar asked this question in Q&A

ondar
Oct 1, 2024

Anyone know if I can use postgres sink (or any other available) for https://github.com/ClickHouse? Or what are the diffrerences?

Answered by pashagolub

No, you cannot use postgres sink because Clickhouse doesn't speak Postgresian.
But you can:

export to json and then import to clickhouse
use a special CDC to read data from postgres
write your own RPC sink implementation or use this one as a starting point

View full answer

Replies: 1 comment

pashagolub
Oct 1, 2024
Maintainer

No, you cannot use postgres sink because Clickhouse doesn't speak Postgresian.
But you can:

export to json and then import to clickhouse
use a special CDC to read data from postgres
write your own RPC sink implementation or use this one as a starting point

0 replies

Answer selected by ondar

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment