Trino query console

Run Trino SQL with per-tab catalog and schema, EXPLAIN plans, named parameters and live statistics for every query.

The Trino console highlights SQL and runs your script one statement at a time. It stops at the first error and does not undo what already ran, because Trino in Tablyne has no transactions. A banner in the console says so.

Tab context

Each tab holds its own catalog, schema and session properties. USE and SET SESSION change that tab. Tablyne does not parse them itself. It reads the server’s answer, so the server decides what they mean. You can also pick the catalog and schema from the tab bar.

Parameters

Parameters are sent as typed values through a prepared statement. They are not pasted into the SQL text.

Plans

The plan menu offers the distributed plan as a tree, the same plan as text, an IO plan that shows what the query will read, and a validation that checks the text and permissions without running. EXPLAIN ANALYZE is also there, and the menu notes that it runs the query and measures each stage.

While it runs

The console shows the query state, such as queued, planning or running. It also shows elapsed time, CPU, rows and bytes processed, bytes read from storage, peak memory and spill. Cancel asks the server to end the query.

Results

The first 1,000 rows appear in the grid. The rest go to a spool file on disk, up to a cap. When the cap is reached, Tablyne ends the query on the server and tells you how many rows arrived. If an error comes after some rows, the result is marked as partial and never as a success.

Limits

Results are read-only. Tablyne checks every statement before sending it, and a write is never sent twice.