# Extract project data with Trino

This tutorial demonstrates how to use the [Trino Connector](/en/product/connectors/sources/connectors/trino/index) to extract data from one project into another on the Platform.

* [Introduction](#introduction)
  * [Requirements](#requirements)
  * [Concepts overview](#concepts-overview)
* [Use the Trino Connector](#use-the-trino-connector)
  * [Steps to follow at source project](#steps-to-follow-at-source-project)
  * [Steps to follow at destination project](#steps-to-follow-at-destination-project)
* [Using the extracted data](#using-the-extracted-data)
---

## Introduction

### Requirements

To follow this tutorial, you need to be familiar with the [Connectors](/en/product/connectors/index.md), [Analytics Manager](/en/product/am/index.md), [Identity Access Manager](/en/product/iam/index.md) and you should preferably have done the [Getting Started guide](/en/getting-started/index). The essential is that you know what [Sources](/en/product/connectors/sources/index.md) are for and how to use them.

### Concepts Overview

It is common to have multiple projects running across the platform. In the scenario where you would want to extract and transfer data from an existing project into another, the *Trino Connector* does the work. 

This is made possible thanks to the **managed Trino query engine** which is part of the [Analytics Manager](/en/product/am/index.md) service. It allows to query the datasets of the project - and can be connected to from the external world.

This tutorial will follow a two-step process:

- Make the required changes at the **source project** to allow the extraction of data.
- Use the Trino Connector at the **destination project** as a source to move the data.

Now let's see how all of this works in practice!

---

## Use the Trino Connector

### Steps to Follow at the Source Project

These initial steps leverage the [Lakehouse Manager](/en/product/lakehouse-manager/index.md) and the [Identity Access Manager](/en/product/iam/index.md).

1.  **Identify Source Catalog and Schema:**
    Find the catalog and schema you intend to connect to in Lakehouse Manager [Explorer](/en/product/lakehouse-manager/explorer/index.md)

    Execute the following SQL commands to retrieve the available catalogs and schemas:

    ```sql
    SHOW CATALOGS
    ```
    Copy and save the desired catalog name as `CATALOG_NAME`.

    ![Trino-Connector](picts/trino-connector-show-catalogs.png)

    ```sql
    SHOW SCHEMAS FROM CATALOG_NAME
    ```
    > **Note:** Replace `CATALOG_NAME` with the actual catalog you selected in the previous step.

    This command will display a list of available schemas within your chosen catalog.

    ![Trino-Connector](picts/trino-connector-show-schemas.png)

    Copy and save the desired schema name as `SCHEMA_NAME`.

    >Upon creation of a new project, the `default dataset` is provided. If you have not established any additional datasets within your project, this is the appropriate selection.

2. Open the *Identity Access Manager* and create a new service account for the purpose of this transfer.

    ![Trino-Connector](picts/trino-connector-service-account.png)

    > Make sure to add *Platform Admin* as the group for this service account

    Once the service account has been successfully create, you need to generate a key for the *API Access*. Click on the add button as shown in the picture below, followed by create.

    ![Trino-Connector](picts/trino-connector-service-account-2.png)

    ![Trino-Connector](picts/trino-connector-create-api-key.png)

    You will be provided with the *API Key* and the *Secret Key*. Make sure to copy and save them securely as you wont be able to access the *Secret Key* once you leave this page.

    ![Trino-Connector](picts/trino-connector-created-api-key.png)

    You have successfully completed all the steps required at the source project; the next part of the tutorial will continue on the destination project.

### Steps to follow at destination project

1. Proceed to the *Connectors* and add a new Trino Source.

![Trino-Connector](picts/trino-connector-add-source.png)

2. Fill in the details as given below and click on connect

 - **Host:** replace by your ***source*** *Project_Name* + `-query.eu.dataplatform.ovh.net`
 - **Port:** 443
 - **Catalog:** replace with your *CATALOG_NAME*
 - **Schema:** replace with your *SCHEMA_NAME*
 - **Username:** replace with *API_KEY*
 - **Password:** replace with *SECRET_KEY*
 - **SSL:** activated

![Trino-Connector](picts/trino-connector-source-settings.png)

3. Once the Trino Connection has been successfully established, the list of available tables will be populated. Click on the box next to table name you desire to extract from the source and click create.


![Trino-Connector](picts/trino-connector-source-connected.png)

---

## Using the extracted data


Once all the previous steps have been completed, you can visit the *Analyzer* tab within the *Connectors* to verify the extracted tables.

To use this extracted data you can follow **step three** of the [Getting Started](/en/getting-started/app-init/dpe.md) Tutorial.

---
##  Need help? 🆘

> If you are logging-in with an OVHcloud account, you can create a ticket to raise an incident or if you need support at the [OVHcloud Help Centre](https://help.ovhcloud.com/csm/fr-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).