Browse Trino data

Browse Trino catalogs, schemas and tables, read structure and DDL, and preview rows with typed filters, sorting and a limit.

The sidebar shows catalogs, then schemas, then tables and views. Each level loads only when you open it, because on Trino the catalog is a query. It takes a place in the cluster queue and can be slow on some connectors. A failing catalog shows its error on its own node and does not break the others. Lists are cut at 2,000 entries and say so.

A table

A table tab has these sections.

  • Structure: columns, types and comments, from DESCRIBE.
  • DDL: the SHOW CREATE text, which you can copy or open in the console.
  • Partitions and Snapshots: the hidden tables of the connector, when it exposes them. If it does not, the tab says the information is not available for that connector.
  • Preview: a SELECT that Tablyne builds from your choices.

The preview

Opening a table reads no data. You press the button to run the preview. In production the preview is always a button, whatever your settings are. You can add typed filters on real columns, pick a sort column and set a row limit from 1 to 1,000. The default is 200. Tablyne does not use OFFSET, because each page would rerun the query. For more rows, raise the limit, use the console or export. Without a sort, the tab warns that the order is not guaranteed.

Why the grid is read-only

Trino results are read-only, and the grid says so. Trino sits on top of many connectors, and not all of them can write or check a row for conflicts. To change data, write the statement in the console, where it is reviewed.

Activity

The Activity view lists your last 200 queries from system.runtime.queries. If your user cannot read that table, the view says so.