Trino Source
Trino is a distributed SQL query engine for big data analytics.
2 minute read
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 Source Tools
| Tool Name | Description |
|---|---|
| trino-execute-sql Tool | A "trino-execute-sql" tool executes a SQL statement against a Trino database. |
| trino-sql Tool | A "trino-sql" tool executes a pre-defined SQL statement against a Trino database. |
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 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.