Clickhouse

4 min

the clickhouse settings pane in the integration module provides you with all the tools needed to set up and manage the clickhouse configuration the clickhouse settings pane includes the following sections clickhouse server displays a list of connection urls for the clickhouse ports this section includes the supported urls that can be used to connect to the clickhouse database, allowing you to enable and manage how clients can connect and retrieve data the urls are comprised of the ip address of the belden horizon data manager and ports (these ports are default and cannot be changed ) 8123 for http 8543 for https 9000 for native 9004 for mysql users displays a list of users that can access clickhouse you can add a user name and password, change the user's password, and remove the user acl displays a list of users that can access a project database for clickhouse you can add an acl for a project with a specific user the entries display the company and project name, the database name, and the user name you can remove an acl entry explore allows you to open the tabix web interface access clickhouse ui to access the clickhouse ui log in to the belden horizon data manager (bhdm) admin console at the following url https //\[bhdm ip address] 8446 from the navigation panel, select integration integration's kafka pane by default appears from integration's navigation sub panel, select clickhouse integration's clickhouse pane appears refer to the following actions you can take on belden horizon data manager admin console's clickhouse pane \[1] change port status state \[2] copy to clipboard server url \[3] action menu edit you can add or remove up to three ip addresses to a network port interface the first two ip addresses are shown next to the network port interface as well as information about any additional ips editing or removing an ip address for a port interface causes the current ip to disconnect enable/disable \[4] show filter / hide filter search by user name \[5] create user \[6] action menu change password remove \[7] show filter / hide filter search by topic (company / project) , database name , or user name \[8] add acl \[9] action menu delete \[10] open tabix see docid\ q11 frgwr coedmspyu72 \[11] copy projectid to clipboard \[12] copy database name to clipboard \[13] copy to clipboard user name