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
-
Go to Destinations and choose ClickHouse
-
Input the following information:
-
Name - A unique and memorable name for this Connector
-
Hostname (IP or URL)
-
Database - The name of the database
-
Port - 8443 default
-
Username (Case sensitive) - STREAMKAP_USER OR the username you chose
-
Password - password
-
Select/Unselect SSL option (Default on)
Click Save
Updated 2 months ago