> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradime.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Starburst/Trino

Trino (formerly PrestoSQL) is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources. As a DinoAI agent environment in Paradime, Trino enables running dbt™ models and queries during DinoAI background agent sessions.

<Warning>
  **IP RESTRICTIONS**

  Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

  👉 See also: [Paradime IP addresses](https://docs.paradime.io/app-help/developers/ip-restrictions).
</Warning>

#### Authentication methods

Trino supports multiple authentication methods. Set `method` to one of these values:

* `LDAP` - Username and password authentication via LDAP. See [LDAP authentication docs](https://trino.io/docs/current/security/ldap.html).
* `JWT` - JSON Web Token authentication. See [JWT authentication docs](https://trino.io/docs/current/security/jwt.html).

#### Setup Instructions

1. Click **Settings** in the top menu bar of the Paradime interface to access **Account Settings**
2. In the left sidebar, click **Connections**
3. Click **Add New** next to the **DinoAI Background Agent Environment** section
4. Select **Trino** and fill out the corresponding fields.
5. In the **Profile Configuration** field, add the following parameters based on your authentication method. Reference the Profile Fields Reference section below for additional context and configurations.

<Tabs>
  <Tab title="LDAP">
    ```yaml theme={"system"}
    method: ldap                            # Authentication method type
    user: analyst@company.com               # Username in required format
    password: ldap_pass_123                 # LDAP authentication password
    host: analytics.galaxy.starburst.io     # Trino server hostname
    database: analytics                     # Target catalog name
    port: 443                               # Server port number
    ```

    See [LDAP authentication docs](https://trino.io/docs/current/security/ldap.html) for additional support.
  </Tab>

  <Tab title="JWT">
    ```yaml theme={"system"}
    method: jwt                                # Authentication method type
    jwt_token: eyJIsInR5cCI6IkpXVCJ9           # Valid JWT token string
    host: analytics.galaxy.starburst.io        # Trino server hostname
    database: analytics                        # Target catalog name
    port: 443                                  # Server port number
    ```

    See [JWT authentication docs](https://trino.io/docs/current/security/jwt.html) for additional support.
  </Tab>
</Tabs>

<Info>
  After adding the configuration, ensure it's properly formatted using a YAML formatter like [YAML Formatter](https://jsonformatter.org/yaml-formatter).
</Info>

6. Provide a dbt™ **Profile Name** (this should match the profile name set in your `dbt_project.yml`).
7. In the **Target** field, enter **`dinoai`**. This is the target your dbt™ project will use during DinoAI background agent sessions.
8. The **Schema** field is pre-configured, but you can change it to specify the schema where dbt™ will build objects.
9. The **Threads** value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

***

#### Example Profile Configuration

<Frame caption="Profile configuration example for 'LDAP' configuration">
  <img src="https://2337193041-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHET0AD04uHMgdeLAjptq%2Fuploads%2FFVrHpko3n6EsVpf1lGMv%2Fimage.png?alt=media&token=9971e9d8-fa04-4509-86f5-b81dfc746283" alt="Profile configuration example for 'LDAP' configuration" />
</Frame>

***

#### Profile Fields Reference

| Field               | Description                                                                                                                       | Example                                                                                                              | Default Value | Required |
| ------------------- | --------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------- | ------------- | -------- |
| type                | Specifies Trino connection type                                                                                                   | `trino`                                                                                                              | None          | ✅        |
| method              | Authentication method (ldap, kerberos, jwt, etc.)                                                                                 | `ldap`                                                                                                               | None          | ✅        |
| user                | The username of the DinoAI agent service user. When connecting to Starburst Galaxy, include the role as a suffix to the username. | Starburst Enterprise / Trino: `user.name` or `user.name@mydomain.com`Starburst Galaxy: `user.name@mydomain.com/role` | None          | ✅        |
| password            | Authentication password (for LDAP)                                                                                                | `your_password`                                                                                                      | None          | ✅        |
| host                | Trino cluster hostname. Do not include the `http://` or `https://` prefix.                                                        | `analytics.galaxy.starburst.io`                                                                                      | None          | ✅        |
| catalog             | Catalog name in Trino cluster                                                                                                     | `analytics_catalog`                                                                                                  | None          | ✅        |
| schema              | Default schema where dbt™ will build objects during DinoAI background agent sessions. Configured in the UI Schema field.          | `reporting`                                                                                                          | None          | ✅        |
| port                | Trino server port number                                                                                                          | `443`                                                                                                                | `443`         | ✅        |
| threads             | Number of concurrent operations. Configured in the UI Threads field.                                                              | `4`                                                                                                                  | `1`           | ❌        |
| roles               | Catalog-specific role assignments                                                                                                 | `system: analyst`                                                                                                    | None          | ❌        |
| session\_properties | Custom Trino session settings                                                                                                     | `query_max_run_time: 4h`                                                                                             | None          | ❌        |
| http\_scheme        | Connection protocol (http/https)                                                                                                  | `https`                                                                                                              | `http`        | ❌        |


## Related topics

- [Starburst/Trino](/products/settings/connections/scheduler-environment/starburst-trino.md)
- [Scheduler environment](/products/settings/connections/scheduler-environment/index.md)
- [DinoAI Background Agent environment](/products/settings/connections/dinoai-background-agent-environment/index.md)
- [Code IDE environment](/products/settings/connections/development-environment/index.md)
