Configure Trino client

Connect with Trino CLI

1. Download the Trino CLI Client.

wget https://repo1.maven.org/maven2/io/trino/trino-cli/472/trino-cli-472-executable.jar

mv trino-cli-472-executable.jar trino

chmod +x trino

2. Connect to Trino with LDAP Authentication.

PATH=/your/java23/home/bin:$PATH ./trino https://$TRINO_HOST:$TRINO_PORT/ --user $YOUR_USER --password

3. Connect to Trino with Kerberos Authentication + SSL (insecure).

PATH=/your/java/home/bin:$PATH ./trino \

 --server https://$TRINO_HOST:$TRINO_PORT/ \

 --insecure \

 --krb5-config-path /etc/krb5.conf \

 --krb5-principal $YOUR_PRINCIPAL \

 --krb5-keytab-path /path/to/your/keytab \

 --krb5-remote-service-name HTTP \

 --debug

4. Connect to Trino with Kerberos Authentication + SSL (secure) via java command.

java \

-Dsun.security.krb5.debug=true \

-Djava.security.debug=gssloginconfig,configfile,configparser,logincontext \

-Dtrino.client.debugKerberos=true \

-jar $executable_trino_jar \

--server https://$TRINO_HOST:$TRINO_PORT/ \

--truststore-path $truststore_path \

--truststore-password $password \

--keystore-path $keystore_path \

--keystore-password  $password \

--krb5-config-path /etc/krb5.conf \

--krb5-principal $YOUR_PRINCIPAL \

--krb5-keytab-path /path/to/your/keytab \

--krb5-remote-service-name HTTP

5. Verify the connection.

At the trino> prompt, run:

show catalogs;

• If successful: You will see the list of configured data sources.
• If unauthorized: You will see an error: Authentication failed: Unauthorized.

Connect with JDBC

Updated JDBC Driver Location on Trino Nodes for ODP Versions:

/usr/odp/3.2.3.3-2/trino/jdbc/trino-jdbc-472.jar    #ODP-3.2.3.3-2

JDBC over LDAP

The following is an example of JDBC connection info required to connect over SSL (and LDAP):

JDBC over Kerberos

• Sample configurations required when connecting with JDBC over Kerberos.

• Configure the driver properties with kerberos details. You can refer to below example.

Connect with ODBC

Trino supports ODBC connectivity through third-party drivers, enabling integration with various BI tools and applications.

• Simba Trino ODBC Driver: Developed by insightsoftware, this driver is widely used for connecting Trino to BI tools like Tableau, Power BI, and Excel. It supports Windows, macOS, and Linux platforms. For detailed installation and configuration instructions, see Simba Trino ODBC Driver Documentation.
• Starburst ODBC Driver: Tailored for Starburst Enterprise, this driver is compatible with Trino and supports multiple operating systems. For more information, see Starburst ODBC Driver Documentation
• Community ODBC Drivers: Open-source projects like the one by Skilld Labs offer community-supported ODBC drivers for Trino. These may require manual setup and are best suited for development or testing environments. For more information, see Skilld Labs Trino ODBC Driver.