Clickhouse

This page will walkthrough the setup of Clickhouse in K using the direct connect method

Integration details

Step 1: Establish Clickhouse Access

The service user/account/role will require permissions to the following:

• ??

Step 2: Create the Source in K

Create an 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

  Open

  

• 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 detials

  • 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

Step 4: Manually run an ad hoc load to test Clickhouse

• Next to your new Source, click on the Run manual load icon

• Confirm how your want the manual run to be completed
  
  

  Open

  

   

• After the source load is triggered, a pop up bar will appear taking you to the Monitor tab in the Batch Manager page. This is the usual page you visit to view the progress of source loads