Trino
Trino is a distributed SQL query engine for big data analytics.
About
Trino is a distributed SQL query engine designed for fast analytic queries against data of any size. It allows you to query data where it lives, including Hive, Cassandra, relational databases or even proprietary data stores.
Available Tools
trino-sql
Execute parameterized SQL queries against Trino.trino-execute-sql
Execute arbitrary SQL queries against Trino.
Requirements
Trino Cluster
You need access to a running Trino cluster with appropriate user permissions for the catalogs and schemas you want to query.
Example
kind: sources
name: my-trino-source
type: trino
host: trino.example.com
port: "8080"
user: ${TRINO_USER} # Optional for anonymous access
password: ${TRINO_PASSWORD} # Optional
catalog: hive
schema: default
Tip
Use environment variable replacement with the format ${ENV_NAME} instead of hardcoding your secrets into the configuration file.
Reference
| field | type | required | description |
|---|---|---|---|
| type | string | true | Must be “trino”. |
| host | string | true | Trino coordinator hostname (e.g. “trino.example.com”) |
| port | string | true | Trino coordinator port (e.g. “8080”, “8443”) |
| user | string | false | Username for authentication (e.g. “analyst”). Optional for anonymous access. |
| password | string | false | Password for basic authentication |
| catalog | string | true | Default catalog to use for queries (e.g. “hive”) |
| schema | string | true | Default schema to use for queries (e.g. “default”) |
| queryTimeout | string | false | Query timeout duration (e.g. “30m”, “1h”) |
| accessToken | string | false | JWT access token for authentication |
| kerberosEnabled | boolean | false | Enable Kerberos authentication (default: false) |
| sslEnabled | boolean | false | Enable SSL/TLS (default: false) |
| disableSslVerification | boolean | false | Skip SSL/TLS certificate verification (default: false) |
| sslCertPath | string | false | Path to a custom SSL/TLS certificate file |
| sslCert | string | false | Custom SSL/TLS certificate content |