wehub-resource-sync
e04ed9c211
CF: Deploy Dev Docs / deploy (push) Has been cancelled
Sync Labels / build (push) Has been cancelled
tests / unit tests (macos-latest) (push) Has been cancelled
tests / unit tests (windows-latest) (push) Has been cancelled
tests / unit tests (ubuntu-latest) (push) Has been cancelled
69 lines
3.1 KiB
Markdown
69 lines
3.1 KiB
Markdown
---
|
|
title: "Trino Source"
|
|
linkTitle: "Source"
|
|
type: docs
|
|
weight: 1
|
|
description: >
|
|
Trino is a distributed SQL query engine for big data analytics.
|
|
no_list: true
|
|
---
|
|
|
|
## About
|
|
|
|
[Trino][trino-docs] 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.
|
|
|
|
[trino-docs]: https://trino.io/docs/
|
|
|
|
|
|
|
|
## Available Tools
|
|
|
|
{{< list-tools >}}
|
|
|
|
## 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
|
|
|
|
```yaml
|
|
kind: source
|
|
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
|
|
```
|
|
|
|
{{< notice tip >}}
|
|
Use environment variable replacement with the format ${ENV_NAME}
|
|
instead of hardcoding your secrets into the configuration file.
|
|
{{< /notice >}}
|
|
|
|
## 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 |
|