1. Create a separate database for the ClickHouse peer called peerdb. This is where tables will be auto created and synced by PeerDB.
   CREATE DATABASE peerdb;
  1. Make sure you have a database user who has permissions for DDL, DML and SELECT operations on ClickHouse.

  2. Create the ClickHouse Peer through UI

    Choose PostgreSQL Peer

    1. Enter all the details Name, Host, Port, User, Password and Database
    2. ClickHouse peer requires AWS S3 for transient staging of data.

    If you are using PeerDB Cloud, you don’t need to enter any of these credentials. We take care of transient staging for you.

    If you are using PeerDB OSS please enter AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_REGION and S3 Bucket while creating the peer. Note that the S3 Bucket should already exist while creating the peer.