Setup Guide - ClickhouseDB

Follow this setup guide to connect ClickhouseDB to DataChannel.

Prerequisites

  • Have a ClickhouseDB database configured and reachable from the DataChannel IPs. Contact support for the list of IP addresses to whitelist incase required.

  • Create a user for DataChannel with SELECT rights on the tables / views you want to pull data from.

  • In case of a heavily utilized production database, it is advisable to connect the read-only replica to pull data from an active ClickhouseDB account with permissions to access data from accounts you’d like to sync. This account needs to be a admin account with delete privileges.

  • You would require ClickhouseDB DB Host, Username, Password, DB Port and DB Name information to add new credentials.

Setup instructions

  1. Select a data destination for your ClickhouseDB Data. If you have not yet added a data warehouse, go to data warehouse tab and add a warehouse.

    Data Warehouse once selected cannot be changed.

  2. Authorise DataChannel to connect to your ClickhouseDB account using any Name, DB Host, Username, Password, DB Port and DB Name using the + icon.

    clickhousedb new creds

  3. Click on + Data Pipeline to start adding data pipelines to your account.

    clickhousedb data source detail

  4. Details of individual objects and reports are available here.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.