domino logo
Latest (5.6)
  • Tech Ecosystem
  • Get Started
  • Domino Cloud
  • Code Assist
  • Collaborate
  • Projects
  • Work with Data
  • Workspaces
  • Environments
  • Executions
  • Deploy Models and Apps
  • Model Monitoring
  • Organizations
  • Security and Credentials
  • Notifications
  • Download the Audit Log
  • Data Planes
  • Search Your Domino Deployment
  • Domino CLI
  • Troubleshooting
  • Get Help
  • Send Feedback
domino logo
About Domino
Domino Data LabKnowledge BaseData Science BlogTraining
User Guide
>
Work with Data
>
Data Sources
>
Connect to Data Sources
>
Connect to Trino

Connect to Trino

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.

Note
Create a Trino data source

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

  1. From the navigation pane, click Data.

  2. Click Connect to External Data.

  3. In the New Data Source window, from Select Data Store, select Trino.

    New data source

  4. 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.

  5. Click Next.

  6. 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.

  7. Click Test Credentials.

  8. If the data source authenticates, click Next.

  9. Select who can view and use the data source in projects.

  10. 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.

Domino Data LabKnowledge BaseData Science BlogTraining
Copyright © 2022 Domino Data Lab. All rights reserved.