For AI agents: the complete documentation index is available at https://docs.dataplatform.ovh.net/llms.txt, the full documentation bundle is available at https://docs.dataplatform.ovh.net/llms-full.txt, and this page is available as Markdown at https://docs.dataplatform.ovh.net/tutorials-trino-external-tools.md.
  • đŸ‡Ŧ🇧 English

    • Integrating OVHcloud Data Platform with External Tools using Trino

    This guide provides a comprehensive walkthrough for creating a Trino integration to be used in a third-party tool

    Objective

    Info

    Looking for the quick way? You can now generate a ready-to-use Trino connection string in a few clicks with a Trino consumer. This guide covers the manual method: useful when you want to set up the service account, role, and connection string yourself, or need fine-grained control over the catalog and permissions.

    This guide provides a comprehensive walkthrough for creating a Trino integration to be used in a third-party tool. You will generate the necessary credentials and construct a connection string to access your data via Trino.

    Steps to Establish a Trino Connection

    Step 1: Create a New Service Account

    1. Log in to the Data Platform.
    2. Navigate to IAM (Identity and Access Manager).
    3. Go to the Roles section and click New Role. Step 1: Create a New Service Account — Superset
    4. Provide a name for the role (e.g., TrinoServiceAccountRole).
    5. Assign the Advanced Data Access Control permissions to this role. This role will be assigned to your service account to grant the necessary Trino access. Step 1: Create a New Service Account — Superset (2) Step 1: Create a New Service Account — Superset (3)
    6. Go to Service Accounts.
    7. Create a new Service Account and give it a name (e.g., Apache Superset Service Account or Metabase Service Account) and an email address. Step 1: Create a New Service Account — Superset (4)
    8. Assign the newly created role (TrinoServiceAccountRole) to this account.
    9. Click Create.
    Info

    For better security and access management, create a dedicated service account when allowing external tools to access your data.

    Step 2: Generate an API Key and Secret Key

    1. Once you have created the Service Account, you will see the section for API Access. Click on + ADD. Step 2: Generate an API Key and Secret Key — Superset
    2. Here you can modify the duration of the keys and also if you want to send a copy to your registered email. Step 2: Generate an API Key and Secret Key — Superset (2)
    3. Critical: Once the modal is closed, the keys cannot be retrieved again. Be sure to save them immediately in a secure location, such as a password manager. These API Key and Secret Key will serve as your Username and Password for the Trino connection. Step 2: Generate an API Key and Secret Key — Superset (3)

    Step 3: Prepare the connection string

    The connection string you will be able to use in your third-party tools will be as follows:

    trino://{Username}:{Password}@{Project}-query.eu.dataplatform.ovh.net:{Port}/{Catalog}
    • Project: Replace {Project} with your specific project name. You can find this name by navigating to any of your existing projects, then clicking the Information icon represented by ℹī¸ in the top right corner of the interface. Your project name will be displayed there.
    • Port: Replace {Port} with the default Data Platform port (443) or a custom port provided by your setup.
    • Catalog: Replace {Catalog} with the catalog you want to query. You can find the catalog you want by executing this SQL command in the explorer of the Lakehouse Manager: SHOW CATALOGS.
      • Example SHOW CATALOGS output: 
        Catalog
-------
tpcds
tpch
db_m8obb5ch_default_dataset
        In this example, db_m8obb5ch_default_dataset is a valid catalog name.
    • Username: Use the API Key generated earlier from IAM in Step 2.
    • Password: Use the Secret Key generated earlier from IAM in Step 2.

    Example:

    trino://XXXX:YYYYYY@demo-query.eu.dataplatform.ovh.net:443/db_m8obb5ch_default_dataset

    Step 4: Use the connection string in your third-party tool

    Once you have prepared your connection string, you can use it to connect your preferred third-party tool (e.g., Apache Superset) to Trino on OVHcloud Data Platform.

    Returning to a Specific Tool Guide?

    • If you came from the Apache Superset integration guide, click here to continue.
    • If you came from the Metabase integration guide, click here to continue.

    Go further

    If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

    Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated Discord channel.

    If you need support with your OVHcloud services, create a request in our Help Centre.

    Join our community of users.