Connecting to Trino
This section contains details for Trino connections.
General information
Field | Description |
---|---|
Data source | Trino |
Supported versions | 405.0 |
Connection string | jdbc:trino://
|
Packaged? |
Yes |
Certified? |
No |
Supported features | |
Estimate job
|
Yes |
Analyze data
|
Yes |
Schedule
|
Yes |
Processing capabilities | |
Pushdown
|
Yes |
Spark agent
|
Yes |
Yarn agent
|
Yes |
Parallel JDBC
|
Yes |
Java Platform version compatibility | |
JDK 8
|
Yes |
JDK 11
|
Yes |
Minimum user permissions
In order to bring your Trino data into Collibra Data Quality & Observability, you need the following permissions.
- Read access on your Trino database tables.
- ROLE_ADMIN assigned to your user in Collibra DQ.
Recommended and required connection properties
Required | Connection Property | Type | Value |
---|---|---|---|
Yes |
Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
Yes |
Connection URL | String |
The connection string path of your Trino connection. When referring to the example below, replace the value between the { } in the Example Important Your connection URL must contain the following substring: Important If your connection URL contains special characters and your Kubernetes deployment of Collibra DQ is a version before 2023.08, then you need to set the following Helm value to ensure you do not receive an invalid connection exception: |
Yes |
Driver Name | String |
The driver class name of your Trino connection.
|
Yes |
Port | Integer |
The port number to establish a connection to the datasource. The default port is |
No |
Source Name | String | N/A |
No |
Target Agent | Option | The Agent that submits your Spark job for processing. |
Yes |
Auth Type | Option |
The method to authenticate your connection. Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types. |
Yes |
Driver Properties | String |
The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
Authentication
This data source supports the following authentication type:
Username/Password
Required | Field | Description |
---|---|---|
Yes |
Username | The username of your Trino account. |
Yes |
Password | The password of your Trino account. |
Limitations
- Trino connection URLs must contain the following substring:
&source=jdbc:presto
- This requirement will be addressed in a future release.
- When using Pushdown for Trino, the following column data types are not supported:
- HYPERLOGLOG
- P4HYPERLOGLOG
- QDIGEST
- SETDIGEST
- TDIGEST