sdk icon indicating copy to clipboard operation
sdk copied to clipboard

Generic SSH support for SQL-based taps and targets

Open aaronsteers opened this issue 2 years ago • 2 comments
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

aaronsteers avatar Jan 24 '23 19:01 aaronsteers