search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.48k stars 3.01k forks source link

Ability to connect via SSH Tunnel #16079

Closed ryan0x44 closed 2 months ago

ryan0x44 commented 1 year ago

We have some databases which we can only connect to via an SSH Bastion Host / Jump Host.

Many database tools (e.g. Metabase, DBeaver) allow you to connect to database via an SSH tunnel.

Currently we overcome this by running a custom sidecar which runs OpenSSH as an SSH Tunnel, but this approach is cumbersome and costly to set-up securely/reliably and to maintain.

It would be great if Trino had support for connecting to databases via SSH Tunnel, including key-based auth (primarily) and password-based auth (where keys may not be an option for some).

hashhar commented 2 months ago

There are no plans to add this. If someone is interested on working on this feel free to reopen and describe how the solution can look like with minimal and non-invasive changes to each connector separately.