search

datamill-co / target-redshift

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

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

Open phanib4u opened 4 years ago

phanib4u commented 4 years ago

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 commented 4 years ago

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.