Visualizing ClickHouse Data with Tabix: A Step-by-Step Guide
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.
- Associate the created Tabix User with a Topic (Company / Project). See the Add ACL option in Clickhouse.
Log into Tabix
To initially enter Tabix UI from the Litmus Edge Manager Admin Console, see the Open Tabix option in Clickhouse. 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/.
[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
