Esc

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 catalogschematable, 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

Connection fields

FieldDescription
HostTrino coordinator hostname.
PortCoordinator HTTP port. Use 8443 for HTTPS clusters.
CatalogDefault catalog (connector) for unqualified queries, e.g. tpch or memory.
SchemaDefault schema within the catalog. Stored in options as schema=NAME.
UserTrino user, sent as the X-Trino-User header.
PasswordOptional 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. SeeSSH tunnels for details.

URI format

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

textConnection 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'sinformation_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.

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

Supported SQL commands

CommandNotes
SELECTQuery data with WHERE filters, JOINs, aggregates, and window functions.
INSERTOn connectors that allow writes.
UPDATEOn connectors that allow writes.
DELETEOn connectors that allow writes.
CREATE / DROPOn connectors that allow writes.