Trino is a distributed SQL query engine. It’s designed to query large data sets that are distributed over one or more heterogeneous data sources. You can use Trino to access data from several types of data stores, regardless of whether Domino has a dedicated connector for them. See the list of Trino connectors for supported data stores.

This topic explains how to connect to Trino from Domino.

Create a Trino data source

Domino recommends that you use a Domino data source to connect to a Trino instance from Domino.

From the navigation pane, click Data.
Click Connect to External Data.
In the New Data Source window, from Select Data Store, select Trino.
Enter the details about your data source:

Host

The URL, hostname, or IP address of your Trino host.

Port

The port number for the connection, such as 443.

Catalog

The name of the Trino catalog where your data is located. For example, if you plan to use the table hive.test_data.test then the catalog name is hive.

Optional: Schema

The name of the Trino schema to use. For example, if you plan to use the table hive.test_data.test then the schema name is test_data.

Data Source Name

The name that identifies the data source.

Optional: Data Source Description

The purpose for the data source.
Click Next.
Specify the credentials for authenticating to Trino. Basic authentication is supported by default. Domino stores the credentials securely in the secret store backed by HashiCorp Vault.
Click Test Credentials.
If the data source authenticates, click Next.
Select who can view and use the data source in projects.
Click Finish Setup.

If your users have Domino permissions to use the data source and enter their credentials, they can now use the Domino Data API to retrieve data with the connector.

See Retrieve Data for more information.

Connect to Trino