This page will walkthrough the setup of Clickhouse in K using the direct connect method.
Integration details
|
Scope |
Included |
Comments |
|---|---|---|
|
Metadata |
YES |
|
|
Lineage |
YES |
|
|
Usage |
No |
|
|
Sensitive Data Scanner |
N/A |
|
Step 1: Establish Clickhouse Access
The service user/account/role will require permissions to the following:
-
Refer to Clickhouse documentation for required permissions
After this step you should have the following information:
-
Tenant Account ID
-
Role
-
Key
-
Secret
Step 2: Create the Source in K
Create a Clickhouse source in K.
-
Select Platform Settings in the side bar
-
In the pop-out side panel, under Integrations click on Sources
-
Click Add Source and select Clickhouse
-
Select Direct Connect and add your Clickhouse Source Settings
-
Name: Give the Clickhouse source a name in K.
-
Host: Enter a hostname for your Clickhouse instance
-
Port: Refer to Network ports | ClickHouse Docs for your Port details
-
Confirm if you want to:
-
Enable data masking
-
Extract meta only
-
-
-
Click Save & Next
-
Setup your Connection details:
-
Host
-
Username and Password
-
-
Test your connection and click Next
Step 3: Schedule Clickhouse source load
-
Select Platform Settings in the side bar
-
In the pop-out side panel, under Integrations click on Sources
-
Locate your new Clickhouse Source and click on the Schedule Settings (clock) icon to set the schedule