Trino Connection

Trino is a massively parallel processing (MPP) SQL query engine designed for fast analytics on large datasets. It enables querying data from multiple data sources using standard SQL. Trino is highly extensible, allowing seamless integration with various data systems.

Leverage Trino within Data Intelligence to establish connections to Trino server, enabling access to diverse catalogs, schemas, and tables for querying data across multiple data sources using natural language.

Connection Configuration #

Configure the connection parameters that are explained below.

Connection Name #

A unique name for creating the connection is to be given

Scope #

Define the connection scope to customize their accessibility.

• Organization: Accessible to organization users across all Gathr projects for usage in applications.

• Project: Accessible to organization users limited to projects that are specified by the connection owner for usage in applications.

• Private: Accessible only to the connection owner for usage in applications.

Connection Type #

Option to choose between either connecting securely using SSH Tunnel or, proceed with a direct connection.

If Connection Type value is SSH Tunnel, additional fields will be displayed as given below:

To know more about SSH Tunneling with Gathr, see SSH Tunneling.

SSH Key #

The SSH key should be provided to authenticate the associated SSH host and SSH user.

SSH Host #

Public IP address of your SSH host.

SSH User #

Default SSH username.

If Connection Type value is Direct Connection, then proceed by updating the following fields.

SSH Port #

Port number used for SSH connections. The default SSH port is 22 unless otherwise specified.

Enable SSL #

Enable this option to use SSL for secure connections if your Trino configuration supports SSL.

Upload Truststore File #

Upload a truststore file if SSL is enabled, as it is required for secure communications.

Hostname #

Hostname or IP of Trino.

Port #

Trino port number.

Username #

Username of the Trino account.

Password #

Password of the Trino account.

After entering all the details, click on the TEST button.

If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated. Click on the CREATE button to save the changes.

If the details are incorrect or the server is down, you will get a message “Connection unavailable”.