ClickHouse can query PostgreSQL directly, plus you can create a refreshable materialized view, which will do it automatically on a schedule: https://clickhouse

ClickHouse can query PostgreSQL directly, plus you can create a refreshable materialized view, which will do it automatically on a schedule: https://clickhouse.com/docs/sql-reference/table-functions/postgresql https://clickhouse.com/docs/sql-reference/table-functions/po... https://clickhouse.com/docs/materialized-view/refreshable-materialized-view https://clickhouse.com/docs/materialized-view/refreshable-ma... Additionally, you can set up incremental import with https://clickhouse.com/blog/postgres-cdc-connector-clickpipes-public-beta https://clickhouse.com/blog/postgres-cdc-connector-clickpipe...