Import and export Trino data

Export a Trino console result to CSV, JSON, Excel or Markdown, with or without rerunning the query. Tablyne does not import into Trino.

Trino export works on a console result. Run the query, then export it.

Two sources

By default the export uses the rows already saved on disk by the run, so nothing runs again. That covers everything the grid holds, up to the console cap. The second choice, “export all”, reruns the same read statement without the row cap and writes straight to the file. The button says that it reruns. Tablyne never reruns a write this way.

Formats

The formats are CSV, JSON, Excel and Markdown. SQL INSERT export is refused, because the available writers target other SQL dialects and a statement that is almost right for Trino is worse than none. Integers too large for a double, decimals, NaN and Infinity are written as text, so no value is rounded. Structures such as rows and arrays are written as JSON. CSV and Excel files neutralize text that a spreadsheet would run as a formula, and you can turn that off in the export dialog.

Jobs

An export runs in the job center with progress, and you can cancel it. The file is written as a partial file and renamed when it is complete. If you cancel a rerun, or it fails, Tablyne ends the query on the server.

What is not available

Tablyne does not import data into Trino and does not copy a Trino table to another connection. Trino reads from connectors and writes depend on each connector, so load data with the tools that fit your connector.

Cost

A rerun is a normal query on the cluster, with your per-run limits applied.