sdk
sdk copied to clipboard
Generic SSH support for SQL-based taps and targets
trafficstars
The goal would be able to support SSH for SQL-based connectivity. Possibly could be implemented as an extension to the SQLConnector class.
A sample implementation from tap-mysql is here: https://github.com/transferwise/pipelinewise-tap-mysql/commit/2f1b0fd4c69a440350c2a92ad2fef8bd417c080e
Note: developers who expect to have a hard-coded port could be broken by this. Ideally it would not require additional work from the tap/target developer, but a one-time update from the developer may be required.
Related:
- https://github.com/MeltanoLabs/tap-postgres/issues/69
- https://github.com/MeltanoLabs/target-postgres/issues/71
- https://towardsdatascience.com/how-to-connect-to-a-postgresql-database-with-python-using-ssh-tunnelling-d803282f71e7#e325