Skip to main content

Connector - Trino

Connecting to Trino​

A profile describes a working environment and can activate multiple connectors at once. Each entry in connectors is a named connection; the one marked "default": true (or the first one) is the engine your queries run on.

The profile file is parsed as JSONC, so // line comments, /* block comments */, and trailing commas are allowed.

~/.wvlet/profiles.json
{
  "profiles": [
    {
      "name": "trino",
      "connectors": [
        {
          "name": "trino",
          "type": "trino",
          "user": "(user name)",
          "password": "(password)",
          "host": "(trino host name, e.g., localhost:8080)",
          "port": 443,
          "catalog": "(your Trino catalog name)",
          "schema": "(your database)"
        }
      ]
    }
  ]
}
$ wv --profile trino 
wv>

Authentication​

Two authentication methods are supported. Values support ${ENV_VAR} interpolation, so secrets can stay out of profiles.json:

  • Password (basic auth) — set "password" on the connector. Requires "useHttps": true; Trino coordinators reject password credentials over insecure connections.
  • Bearer token (JWT / OAuth2) — set a "token" property. Takes the place of a password (setting both is rejected).
~/.wvlet/profiles.json
{
  "profiles": [
    {
      "name": "trino-jwt",
      "connectors": [
        {
          "name": "trino",
          "type": "trino",
          "host": "trino.example.com",
          "useHttps": true,
          "catalog": "hive",
          "schema": "default",
          "properties": {
            "token": "${TRINO_ACCESS_TOKEN}"
          }
        }
      ]
    }
  ]
}

The Authorization header is sent on every request of the query lifecycle (initial submission, result pagination, and cancellation), so gateways that authenticate each request work out of the box.

Connecting to Trino at Treasure Data​

~/.wvlet/profiles.json
{
  "profiles": [
    {
      "name": "td",
      "connectors": [
        {
          "name": "td",
          "type": "trino",
          "user": "${TD_API_KEY}",
          "password": "dummy",
          "host": "api-presto.treasuredata.com",
          "port": 443,
          "catalog": "td",
          "schema": "(your database name)"
        }
      ]
    }
  ]
}
$ wv --profile td
wv>