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