Hello. What are my options if I need

tap-postgres

and

target-redshift

, and both are behind SSH bastion servers? The Postgres tap supports SSH tunneling configuration, but that's not the case for the Redshift target (which doesn't seem to be actively maintained BTW). Am I out of luck?

While the target hasn't been updated there's still a good amount of active projects using it https://hub.meltano.com/loaders/target-redshift so I wouldn't worry too much myself Are you sure you need a bastian to write to redshift?

Yes, it's a company policy to not expose database endpoints, including Redshift.

I'd probably write a script that runs before the target to establish the ssh tunnel