How-To Guides
Litmus Edge Manager Admin Cons...

Visualizing ClickHouse Data with Tabix: A Step-by-Step Guide

4min
tabix can be used to retrieve and display plc data from a litmus edge manager you can then execute sql queries onto the plc data before you begin ensure that the clickhouse port 8543 \[ https ] is enabled see the change port status state option in clickhouse docid\ md6nfaz8rrs1p jwpaim create a clickhouse user see the create user option in clickhouse docid\ md6nfaz8rrs1p jwpaim associate the created tabix user with a topic (company / project) see the add acl option in clickhouse docid\ md6nfaz8rrs1p jwpaim log into tabix to initially enter tabix ui from the litmus edge manager admin console, see the open tabix option in clickhouse docid\ md6nfaz8rrs1p jwpaim you can click the https conn button to automatically fill in the title and url title by default, this is https conn url https // followed by the ip address / domain name of the litmus edge manager instance, followed by 8543 user this is the clickhouse username that was created from earlier and associated with a topic password this is the clickhouse user's respective password that was created from earlier mode keep it as normal mode once you are successfully logged in, all the database name (s) that were created from an association between a clickhouse user and topics (company/project) will be available using tabix from there, you can view additional data and execute sql queries in tabix for more information about tabix, see https //tabix io/doc/ https //tabix io/doc/ \[1] access default sql query drop down menu right click on one of the five tables below the database name \[2] enter sql query see clickhouse sql reference for details \[3] run current sql \[4] view sql query results example sql query on tabix