# Deploying Apache Superset on OVHcloud Data Platform

This guide provides a comprehensive walkthrough for deploying Apache Superset on the OVHcloud Data Platform, covering installation, configuration, and Trino integration for a secure and reliable setup.

**Before you begin:**
You will need an active Trino connection string. The easiest way is to create a [**Trino consumer**](/en/product/connectors/consumers/trino/index.md) in the Connectors; alternatively, build one manually by following [Integrating Trino with External Tools](/en/getting-further/integrate-trino-with-external-tools/index.md). This connection string is crucial for configuring Trino within Apache Superset.

## Table of Contents

*  [Steps to Connect Apache Superset to Data Platform via Trino](#steps-to-connect-apache-superset-to-data-platform-via-trino)
    *   [Step 1: Add Apache Superset into Application Services](#step-1-add-apache-superset-into-application-services)
    *   [Step 2: Customize the Template (Editor Tab)](#step-2-customize-the-template-editor-tab)
    *   [Step 3: Configure Trino in Apache Superset](#step-3-configure-trino-in-apache-superset)
    *   [Step 4: Create Your First Chart](#step-4-create-your-first-chart)

## Steps to Connect Apache Superset to Data Platform via Trino

### Step 1: Add Apache Superset into Application Services

1.  Navigate to your project.
2.  Click **Create an application** in the tile **Application Services**.
    ![apache_superset_into_data_platform](picts/superset-09.png)
3.  Select **Apache Superset**.
    ![apache_superset_into_data_platform](picts/superset-10.png)
4.  In the Apache Superset Store, select the Template you want (for this tutorial, we will select v5.0.0 with SQLite).
    ![apache_superset_into_data_platform](picts/superset-11.png)

> The SQLite file will be stored in the **appservice** folder of the S3 bucket (Lakehouse Manager section). We highly recommend backing up this file regularly.

5.  Provide a name for the new application (e.g., `dashboard`).
    ![apache_superset_into_data_platform](picts/superset-12.png)
6.  Build the application.
7.  Once built, deploy the application by clicking on the **Deploy** button.

### Step 2: Customize the Template (Editor Tab)

In the **Editor** tab of your application, you have access to the full source code of the template. You can modify it as needed.

This includes:

*   The overridden **Apache Superset source code** used in the template.
*   A technical **`README.md`** file that explains the structure and customization points of the template.
*   The **`entrypoint.sh`** script, which manages backup and restoration of the **`sqlite.db`** file.
*   The standard **`forepaas.json`** file, present in all AppService deployments, which defines:
    *   The version of Apache Superset being used
    *   The configuration for **role mapping** and runtime parameters

> Modifying this template allows advanced customization of Superset behavior, layout, and deployment logic.

![apache_superset_into_data_platform](picts/superset-23.png)

### Step 3: Configure Trino in Apache Superset

1.  Open Apache Superset by clicking on the **Open** button.

![apache_superset_into_data_platform](picts/superset-13.png)

2.  Click **Sign In With DataPlatformSSO**. Once redirected, you will be connected to Superset.

![apache_superset_into_data_platform](picts/superset-14.png)

3.  In the **Settings** menu, click **Database Connections**.

![apache_superset_into_data_platform](picts/superset-15.png)

4.  Click **+ Database**.

![apache_superset_into_data_platform](picts/superset-16.png)

5.  Select **Trino** in the **Supported databases** list.

![apache_superset_into_data_platform](picts/superset-17.png)

6.  Paste the **full Trino connection string** (from your [Trino consumer](/en/product/connectors/consumers/trino/index.md), or built manually per the [Integrating Trino with External Tools](/en/getting-further/integrate-trino-with-external-tools/index.md) guide) into the **SQLAlchemy URI** field and validate the form.

![apache_superset_into_data_platform](picts/superset-19.png)

### Step 4: Create Your First Chart

1.  Click **`Datasets`** in the main menu.
2.  Click the **`+ Dataset`** button.
3.  Once the **New dataset** page is loaded, fill out the form with the following:

    *   **Database**: The Trino database you have just created.
    *   **Schema**: The catalog you want to query (e.g., `db_m8obb5ch_default_dataset`).
    *   **Table**: A table from your selected catalog (e.g., `dataset_history`).
    ![apache_superset_into_data_platform](picts/superset-20.png)

4.  Click the **Create dataset and create chart** button.
5.  Once created, you will be redirected to the **Create a new chart** form.
6.  Select a chart (e.g., **Pie Chart**).
    ![apache_superset_into_data_platform](picts/superset-21.png)
7.  Complete the **Query** fields (e.g., **Dimensions**: **`cat_temperature`** & **Metric**: **`Sum(rides)`**).
8.  Click the **Create chart** button.
    ![apache_superset_into_data_platform](picts/superset-22.png)

> For more information, see the [Apache Superset documentation](https://superset.apache.org/docs/intro/).

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