Connector
Trino / Starburst
Connect to a Trino or Starburst cluster. The builder shows a query's columns without running it.
Settings
What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.
| Host | |
| Port | 443 for HTTPS / Starburst Galaxy, 8080 for a local Trino cluster. |
| Protocol | Choices: https; http. |
| Default catalog | Optional default catalog (e.g. hive); the node can still address any catalog. |
| Default schema | Optional default schema (e.g. default). |
| Username | |
| Password | Required for HTTPS Basic auth; leave blank for an unauthenticated cluster. Stored encrypted, and never shown again after you save it. |
Testing the connection
Test runs SELECT 1 and waits for it to finish.
Good to know
- Nodes browse catalog, then schema, then table.
- A default catalog is optional; a node can still address any catalog.
Nodes that use it
Database Lookup
Look up each row's keys in a database table and add the matching row's columns.
Trino / Starburst input
Read a table or SQL query from a Trino / Starburst cluster. A Bookmark can read only the rows added or changed since the last successful run.
Trino / Starburst output
Load rows into a Trino / Starburst table (append or truncate; auto-creates). Turn on All or nothing and an append that fails leaves the table as it was.