---
title: Visualizing ClickHouse Data with Tabix: A Step-by-Step Guide
slug: edgemanager/how-to-guides/lem-admin-console-guides/access-tabix-ui-with-litmus-edge-manager
description: Tabix can be used to retrieve and display PLC data. You can then execute SQL queries onto the PLC data. 
docTags: 
createdAt: 2023-03-03T14:54:25.000Z
---

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*.

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/B8p0kQUgGEJ1TwfcotN4f_image.png" size="80" width="1502" height="669" caption="Logging into Tabix" position="center" showCaption="true"}

- **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.

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/i4uHJS9_vDzKGztJOCJDP_image.png" size="80" width="1920" height="866" caption="Database names same" position="center" showCaption="true"}

## 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/).

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/8oHACJq1_3hRXexRa3Xiq_image.png" size="80" width="1920" height="866" caption="Tabix UI" position="center" showCaption="true"}

\[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](https://clickhouse.com/docs/en/sql-reference) for details

\[3] **Run current SQL**

\[4] **View SQL query results**

## Example SQL Query on Tabix

::Image[]{src="https://api.archbee.com/api/optimize/SSUUxKZUk9bFTEPNn_6Zo/2Z-7cvTI2jCPeetPU0Bk__image.png" size="80" width="1836" height="807" caption="Example Tabix UI" position="center" showCaption="true"}