search

datamill-co / target-redshift

A Singer.io Target for Redshift
MIT License
23 stars 17 forks source link

SSH tunneling #44

Open aroder opened 4 years ago

aroder commented 4 years ago

Support a jump server for cases when Redshift is behind a firewall and not exposed to the internet

awm33 commented 4 years ago

Hi @aroder , thanks for interest in contributing.

I think that:

1) Setting up SSH / VPN / networking seems out of scope for a particular target and more like something that a bash script should be doing. A large number of taps and targets (pretty much and db or API that can be run on-prem) could use SSH tunneling. 2) If we were to add it, I would be more inclined to add it to target-postgres's target_tools.py which is used by target-redshift and target-snowflake.

awm33 commented 4 years ago

CC @AlexanderMann

AlexanderMann commented 4 years ago

@awm33 is there any movement here or anything to be done here?

chriskl commented 3 years ago

I suggest adding support for redshift's data api which is vastly superior than tunneling anyway