# Integrating OVHcloud Data Platform with External Tools using Trino

?> **Looking for the quick way?** You can now generate a ready-to-use Trino connection string in a few clicks with a [**Trino consumer**](/en/product/connectors/consumers/trino/index.md). 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.

## Table of Contents

*  [Steps to Establish a Trino Connection](#steps-to-establish-a-trino-connection)
    *   [Step 1: Create a New Service Account](#step-1-create-a-new-service-account)
    *   [Step 2: Generate an API Key and Secret Key](#step-2-generate-an-api-key-and-secret-key)
    *   [Step 3: Prepare the connection string](#step-3-prepare-the-connection-string)
    *   [Step 4: Use the connection string in your third-party tool](#step-4-use-the-connection-string-in-your-third-party-tool)

## 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**.
    ![apache_superset_into_data_platform](picts/superset-02.png)
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.
    ![apache_superset_into_data_platform](picts/superset-03.png)
    ![apache_superset_into_data_platform](picts/superset-04.png)
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.
    ![apache_superset_into_data_platform](picts/superset-05.png)
8.  Assign the newly created role (`TrinoServiceAccountRole`) to this account.
9.  Click **Create**.

> 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**.
    ![apache_superset_into_data_platform](picts/superset-06.png)
2.  Here you can modify the duration of the keys and also if you want to send a copy to your registered email.
    ![apache_superset_into_data_platform](picts/superset-07.png)
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.
    ![apache_superset_into_data_platform](picts/superset-08.png)

### Step 3: Prepare the connection string

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

```url
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:**
        ```text
        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:**
```url
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](/en/getting-further/install-apache-superset/index.md) to continue.
*   If you came from the Metabase integration guide, click [here](/en/getting-further/metabase-trino-connector/index.md) to continue.

## Need Help? 🆘

If you are logging in with an OVHcloud account, you can create a ticket to raise an incident or get support at the [OVHcloud Help Centre (English)](https://help.ovhcloud.com/csm/en-home?id=csm_index). Additionally, you can ask for support by reaching out to us on the Data Platform Channel within the [Discord Server](https://discord.com/channels/850031577277792286/1163465539981672559). There is a step-by-step guide in the [support](/en/support/index.md) documentation.