ClickHouse

Stream change data capture data into ClickHouse with Streamkap

Prerequsites

  • ClickHouse User
  • Accessible endpoint

ClickHouse Setup

CREATE ROLE STREAMKAP_ROLE;
GRANT SELECT, CREATE, SHOW, INSERT, ALTER, DROP, TRUNCATE ON <db name>.* TO STREAMKAP_ROLE;
CREATE USER STREAMKAP_USER IDENTIFIED WITH plaintext_password BY 'setpassword'
GRANT STREAMKAP_ROLE TO STREAMKAP_USER;

Streamkap Setup

  1. Go to Destinations and choose ClickHouse

  2. Input the following information:

  3. Name - A unique and memorable name for this Connector

  4. Hostname (IP or URL)

  5. Database - The name of the database

  6. Port - 8443 default

  7. Username (Case sensitive) - STREAMKAP_USER OR the username you chose

  8. Password - password

  9. Select/Unselect SSL option (Default on)

Click Save