Communication between Trino and a client can be secured with HTTPS protocol.
config.properties Trino setup file located in
/etc/trino folder includes the information necessary for establishing a connection to DBeaver. Java Keystore file contains a public key which is required to connect DBeaver to Trino cluster secured with SSL/TLS. Also, it is possible to disable SSL verification.
This step can be skipped if SSL verification is disabled (option 2 below) in a connection. Find a file defined in
http-server.https.keystore.pathvariable. The file can be in two formats: Java keystore (
.jks) or certificate (
.pem). Java keystore works for DBeaver. Certificate can be converted into Java keystore as well. It is recommended to remove private key from Java keystore. Place the file in any location where accessible by DBeaver . It might be
C:\DBeaverDBeaver root folder.
Create Trino connection.
Replace Host with your Trino coordinator FQDN and port with your Trino HTTPS one, and add user name on Main tab.
Switch to Driver properties tab.
trueon Driver properties tab.
Add properties on Driver properties tab.
Option 1 with SSL verification
SSLKeyStorePath: path to Java Keystore file, for example,
SSLKeyStorePassword: Java Keystore file password
Option 2 without SSL verification