The Schema tab
The Schema tab lets you view the databases and tables in your ClickHouse® cluster. You can then select a table and see its details.
Figure 1 - The Schema tab
You can click the Show system tables checkbox to see the system tables as well. All of the table names are links. You can also click the 
filter icon to show only the tables that match a particular value. This example filters the display to show only tables from the mindsdb database:
Figure 2 - Filtering to tables from a single database
You can create as many filters as you want; you could add a filter to the display in Figure 6 to show only tables in the mindsdb database with a MaterializedView engine.
When you’re ready to see more details on a particular table, click on a table name to see the Table Details dialog, which has four subtabs:
- The Table Description tab - Lists dozens of properties of the table, including its engine, size, number of rows, partition key, and sorting key.
- The Table Schema tab - Displays the table schema via the
CREATEstatement that created it. - The Sample Rows tab - Shows some rows from the table.
- The Column Compression tab - Details the compression ratios of each column in the table.
The Table Description tab
The Table Description tab has a table of the table’s properties. There are dozens of them, some of which are shown here:
Figure 3 - The Table Description tab
The Table Schema tab
The Table Schema tab displays the table’s schema via the CREATE statement that created it:
Figure 4 - The Table Schema tab
Click the Copy to Clipboard link to put the schema on the clipboard.
The Sample Rows tab
The Sample Rows tab shows randomly selected rows from the table:
Figure 5 - The Sample Rows tab
Be aware that some kinds of tables won’t have any sample records.
The Column Compression tab
Finally, the Column Compression tab shows the details of the columns in the table and how much they have been compressed:
Figure 6 - The Column Compression tab
The key_flags data indicates whether a given column is the partition key, the primary key, the sorting key, and/or the sampling key. In the example in Figure 6, .xx. means this column is in the primary key and the sorting key.