[kossae]

I’m actually in the same boat right now (primary DB -> Clickhouse). We’re currently trialing Airbyte but it appears they’re removing normalization support for Clickhouse this year. Did you land on a custom solution, or some other ETL/ELT tool?

[benjaminwootton]

Have you tried the PostgreSQL table engine?

Or Debezium to Kafka for a more hand coded solution?

[higeorge13]

The materialized postgres is still experimental and has some backlog until being production ready.

Debezium -> kafka -> kafka engine -> MVs -> Replacing merge trees works like a charm for me.