Prerequsites

• ClickHouse User
• Accessible endpoint

ClickHouse Setup

CREATE ROLE STREAMKAP_ROLE;
GRANT SELECT, CREATE, SHOW, INSERT  ON <db name>.* TO STREAMKAP_ROLE;

CREATE USER streamkap_user IDENTIFIED WITH sha256_password BY 'set_a_new_password'
GRANT STREAMKAP_ROLE TO streamkap_user;

Using Final modifier

Using Final is not recommended by ClickHouse but we've seen situations where it is required.

If you would like FINAL to always be applied when querying, adjust the role

ALTER ROLE STREAMKAP_ROLE SETTINGS final = 1;

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