dbt to connect to Trino with SSL error

Help
1

Hello,

I tried using dbt to connect to Trino. This is how I connect using the Trino CLI:

trino --server=https://wctrino.com:8088 --user=test --password --keystore-path=./tls/trino.jks --keystore-password=1qazXSW@

It connects successfully and works. But I don’t know how to add the keystore information in the profiles.yml.

dev:
type: trino
method: ldap
user: test
password: 1qazXSW@
host: wctrino.com
database: ORCL
schema: C360_DEMO
port: 8088
threads: 1

Error Message:
(dbt-env) [root@starburst-1 my_dbt_project]# dbt debug
Running with dbt=0.21.0
dbt version: 0.21.0
python version: 3.6.8
python path: /opt/dbt-env/bin/python
os info: Linux-4.18.0-372.9.1.el8.x86_64-x86_64-with-redhat-8.6-Ootpa
Using profiles.yml file at /root/.dbt/profiles.yml
Using dbt_project.yml file at /opt/my_dbt_project/dbt_project.yml

Configuration:
profiles.yml file [OK found and valid]
dbt_project.yml file [OK found and valid]

Required dependencies:

  • git [OK found]

Connection:
host: wctrino.com
port: 8088
user: test
database: ORCL
schema: C360_DEMO
Connection test: [ERROR]

1 check failed:
dbt was unable to connect to the specified database.
The database returned the following error:

Runtime Error
HTTPSConnectionPool(host='wctrino.com', port=8088): Max retries exceeded with url: /v1/statement (Caused by SSLError(SSLError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:897)’),))