---
title: "Integrating OVHcloud Data Platform with External Tools using Trino"
description: "This guide provides a comprehensive walkthrough for creating a Trino integration to be used in a third-party tool"
url: https://docs.ovhcloud.com/de/guides/public-cloud/data-platform/tutorials-trino-external-tools
lang: de
lastUpdated: 2026-09-14
---
> For AI agents: the complete documentation index is available at https://docs.ovhcloud.com/de/llms.txt, the full documentation bundle is available at https://docs.ovhcloud.com/de/llms-full.txt.
# Integrating OVHcloud Data Platform with External Tools using Trino
## 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**](https://docs.ovhcloud.com/de/guides/public-cloud/data-platform/connectors-consumers-trino.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.
## 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**.
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.
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.
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**.
2. Here you can modify the duration of the keys and also if you want to send a copy to your registered email.
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 3: Prepare the connection string
The connection string you will be able to use in your third-party tools will be as follows:
```text
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:**
```text
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](https://docs.ovhcloud.com/de/guides/public-cloud/data-platform/tutorials-install-apache-superset.md) to continue.
- If you came from the Metabase integration guide, click [here](https://docs.ovhcloud.com/de/guides/public-cloud/data-platform/tutorials-metabase-trino.md) to continue.
## Go further
If you need training or technical assistance to implement our solutions, contact your sales representative or click on [this link](https://www.ovhcloud.com/de/professional-services/) 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](https://discord.gg/ovhcloud).
If you need support with your OVHcloud services, create a request in our [Help Centre](https://help.ovhcloud.com/csm?id=csm_get_help).
Join our [community of users](https://community.ovhcloud.com/).