Integration
Trino
Distributed SQL query engine
- Category
- Data warehouses
- Runs in
- The Phloem cloud — nothing to install
Lets you and Hamming query a Trino catalog with SQL, with its tables listed in Trace.
What Phloem reads
- Tables and views in every schema of the catalog, with their columns, listed in Trace for Hamming and SQL autocomplete
information_schemais left out
What you need
- The coordinator's hostname and HTTP or HTTPS port, reachable from Phloem
- The catalog to read
- A Trino username, plus a password if the cluster uses password sign-in
Connect
- In the console, open Connectors, choose Add connector, then Trino.
- Enter Host, Port and Catalog. Optional: a default Schema (default
default). - Enter Username, and Password if your cluster needs one.
- Check Use SSL/HTTPS to connect over HTTPS. Clear Verify SSL Certificate only for a self-signed certificate.
- Choose Test Connection, then Create Connection.
What Hamming can do
- Run SQL that you or Hamming write, as the username you entered
Notes
- One connector reads one catalog. Add a connector for each catalog you want in Trace.
- Phloem runs any statement, not only
SELECT. Give the user read-only access in Trino to keep the connector read-only.
#Connection fields
What the Add connector form asks for.
| Field | Type | Required |
|---|---|---|
| Host Trino coordinator hostname trino.example.com | Text | Yes |
| Port HTTP/HTTPS port 8080 | Number | Yes |
| Catalog Default catalog to connect to hive | Text | Yes |
| Schema Default schema (optional) default | Text | — |
| Username Username for authentication trino_user | Text | Yes |
| Password Password (optional, for basic auth) | Secret | — |
| Use SSL/HTTPS Connect using HTTPS | On / off | — |
| Verify SSL Certificate Verify SSL certificate (disable for self-signed certs) | On / off | — |
Updated