PeerDB is now natively integrated with ClickHouse Cloud!We recently announced the Postgres CDC connector in ClickPipes, now available in Public Preview.
This connector is fully powered by PeerDB.As a ClickHouse Cloud customer, you get a seamless, native experience for moving data from your Postgres databases to ClickHouse Cloud. Simply navigate to the Data Sources tab and add a Postgres source to start ingesting data.The Postgres ClickPipe is in Public Beta
You can create a Clickhouse peer using this endpoint. Here is the request and response format for creating a Clickhouse peer.
Note that the Clickhouse peer uses an intermediary S3 stage under the hood for performance. The S3 fields related to this are optional, because:
For PeerDB Cloud, the S3 bucket is managed by PeerDB
For PeerDB OSS, a minio bucket is provided as part of the stack.