> ## 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
> Connect Starburst or Trino to Paradime to run dbt™ against your Starburst Galaxy or Trino cluster from the Code IDE, Bolt, and Agent.
[Trino](https://trino.io/) (formerly PrestoSQL) is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources. Connect it to Paradime to run dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent work against your cluster.
**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](/developers/ip-restrictions).
**Available in:** Code IDE, Bolt, and Agent environments.
## 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).
* `oauth_console`: Open Authentication (OAuth) with the authentication URL printed to the console. See [OAuth 2.0 authentication docs](https://trino.io/docs/current/security/oauth2.html).
## Add a connection
1. Click **Settings** in the top menu bar of the Paradime interface to access **Workspace Settings**.
2. In the left sidebar, click **Environments**.
3. Click **Add New** next to the section for the environment you are configuring:
* **Code IDE** for the Code IDE connection
* **Bolt** for the Bolt connection
* **Agent** for the Agent connection
4. Select **Trino**.
5. In the **Profile Configuration** field, add the parameters for your authentication method (see [Profile configuration](#profile-configuration) below). Reference the [Profile fields reference](#profile-fields-reference) section for additional context and configurations.
6. Provide a dbt™ **Profile Name** (this should match the profile name set in your `dbt_project.yml`).
7. In the **Target** field, enter the target for the environment: `dev` for Code IDE, `prod` for Bolt, or `dinoai` for the Agent.
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.
## Profile configuration
Add the following parameters to the **Profile Configuration** field based on your authentication method.
```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.
```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.
```yaml theme={"system"}
method: oauth_console # Authentication method type
host: analytics.galaxy.starburst.io # Trino cluster hostname without http(s)://
catalog: dbt_target_catalog # Catalog name in Trino cluster
schema: db_schema # Default schema where dbt will build objects
port: 443 # Trino server port number
```
See [OAuth 2.0 authentication docs](https://trino.io/docs/current/security/oauth2.html) for additional support.
After adding the configuration, ensure it's properly formatted using a YAML formatter like [YAML Formatter](https://jsonformatter.org/yaml-formatter).
## 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 account) to log in to your cluster. When connecting to Starburst Galaxy clusters, you must include the role of the user as a suffix to the username. | Format for Starburst Enterprise or Trino: `user.name` or `user.name@mydomain.com`. Format for 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. This is configured in the UI "Schema" field. | `reporting` | None | ✅ |
| port | Trino server port number | `443` | `443` | ✅ |
| threads | Number of concurrent operations. This is 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
Set additional `profiles.yml` attributes for this connection.
## Related topics
- [Bolt environment](/products/settings/connections/scheduler-environment/index.md)
- [Agent environment](/products/settings/connections/dinoai-background-agent-environment/index.md)
- [Code IDE environment](/products/settings/connections/development-environment/index.md)
- [Trino Tools](/products/dino-ai/tools-and-features/warehouse-tool/trino-tools.md)
- [Tools Reference](/products/dino-ai/programmable-agents/tools-reference.md)