Trino connection

To access your data in Trino, create a connection asset for it.

Trino is an open-source, distributed SQL query engine that lets you query data across many sources (lakes, warehouses, databases).

Supported versions

  • Trino version 469

Create a connection to Trino

Create a connection to Trino based on your deployment:

Common connectivity

To create the connection, you need the following connection details:

  • Hostname or IP address: Hostname or IP address of the Trino service
  • Port: Port number of the Trino service

Credentials

  • Username and Password: The username and associated password to access the for the Trino service.
  • SSL certificate: The SSL certificate of the host to be trusted. The certificate is needed only when the host certificate is not signed by a known certificate authority.

Select Port is SSL-enabled (optional): Enable if the port is configured to accept SSL connections.

  • SSL certificate: The SSL certificate of the host to be trusted which is only needed when the host certificate was not signed by a known certificate authority.

For Credentials, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection cannot be created in a FIPS environment.

Trino setup

Installation

Running SQL statements

To ensure that your SQL statements run correctly, refer to the SQL statement syntax for the correct syntax.

Restrictions

You can use this connection for source data only. You cannot write to data or export data with this connection.

Learn more