singer target-redshift, not able to connect to Redshift due to issue with SSL

[phanib4u]

The connectivity was good to the redshift from dbeaver with a set of creds and was able to intract on the redshift. But the same creds and details when used with singer target-redshift, not able to connect.
The current target-redshift do not support passing "SSL true". Could you help with the same ?

[AlexanderMann]

We should be able to port over the enhancements made in Target Postgres for connection creation. There's also probably an enhancement to make here in general where we can allow for the full connection details to just be a dictionary we hand off to PsycoPG, but it would more closely match how we're creating/dealing with everything for S3.