Starburst/Trino - Paradime

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.

IP RESTRICTIONSMake sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.👉 See also: Paradime IP addresses.

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.
JWT - JSON Web Token authentication. See JWT authentication docs.

Setup Instructions

Click Settings in the top menu bar of the Paradime interface to access Account Settings
In the left sidebar, click Connections
Click Add New next to the DinoAI Background Agent Environment section
Select Trino and fill out the corresponding fields.
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.

LDAP
JWT

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 for additional support.

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 for additional support.

After adding the configuration, ensure it’s properly formatted using a YAML formatter like YAML Formatter.

Provide a dbt™ Profile Name (this should match the profile name set in your dbt_project.yml).
In the Target field, enter dinoai. This is the target your dbt™ project will use during DinoAI background agent sessions.
The Schema field is pre-configured, but you can change it to specify the schema where dbt™ will build objects.
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

Profile configuration example for 'LDAP' configuration

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`	❌

​Authentication methods

​Setup Instructions

​Example Profile Configuration

​Profile Fields Reference

Authentication methods

Setup Instructions

Example Profile Configuration

Profile Fields Reference