dlt-hub / dlt

data load tool (dlt) is an open source Python library that makes data loading easy 🛠️
https://dlthub.com/docs
Apache License 2.0
2.65k stars 176 forks source link

Support for ssh tunnelling for database connections. #2049

Open tomtomau opened 5 days ago

tomtomau commented 5 days ago

Feature description

I'm using DLT with Dagster to load data from miscellaneous sources.

I want to be able to load data from a MySQL database that requires connecting via an SSH proxy to enter the VPC.

In Sling, I can specify ssh_tunnel and ssh private key etc. and it automatically connects through the proxy.

Are you a dlt user?

Yes, I run dlt in production.

Use case

I want to be able to load data from a MySQL database that requires connecting via an SSH proxy to enter the VPC.

Proposed solution

I want to specify ssh_tunnel and ssh_private_key etc and the database connection will run through that ssh tunnel.

Related issues

No response