Trino

Overview

Trino is a distributed SQL query engine built for fast analytics over large data sets. Rather than storing data itself, Trino federates queries across many connectors — Hive, Iceberg, PostgreSQL, MySQL, Kafka, object stores, and dozens more — under a single ANSI SQL interface. Its model is catalog → schema → table, where each catalog is a configured connector to an underlying system. Trino runs as a coordinator plus worker cluster and is the open-source engine behind Starburst.

Driver

Crate: reqwest
Version: 0.13

Connection fields

Field	Description
Host	Trino coordinator hostname.
Port	Coordinator HTTP port. Use `8443` for HTTPS clusters.
Catalog	Default catalog (connector) for unqualified queries, e.g. `tpch` or `memory`.
Schema	Default schema within the catalog. Stored in `options` as `schema=NAME`.
User	Trino user, sent as the `X-Trino-User` header.
Password	Optional password for HTTP basic auth. Stored in the macOS Keychain.

All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. See SSH tunnels for details.

URI format

Instead of filling in each field individually, you can paste a connection URI into the Paste URI field. Arris parses the URI and populates all fields automatically.

text Connection URI

trino://user:password@host:8080/catalog?schema=default

The path segment maps to the default catalog and the schema query parameter sets the default schema. Cluster URLs copied from a managed Trino or Starburst deployment can be pasted directly — Arris extracts the host, port, and catalog automatically.

SSL & TLS

Set SSL Mode to a TLS-enabling value to connect over https; combined with a password this sends HTTP basic auth credentials securely to the coordinator. Production Trino clusters typically expose HTTPS on port 8443, while a local development cluster serves plain http on 8080.

Schema browser

Once connected, Arris runs SHOW CATALOGS to list the catalogs as top-level nodes. Pick one in the Catalogs selector and Arris queries that catalog's information_schema to load its schemas, their tables and views, and each column with its type. Catalogs load on demand, so connecting stays fast even against a server with many connectors. Each schema groups its objects by category.

Tables — base tables
Views — views

Double-click any table or view to open it in a new tab with browse mode.

Supported SQL commands

Command	Notes
`SELECT`	Query data with `WHERE` filters, `JOIN`s, aggregates, and window functions.
`INSERT`	On connectors that allow writes.
`UPDATE`	On connectors that allow writes.
`DELETE`	On connectors that allow writes.
`CREATE` / `DROP`	On connectors that allow writes.