Hello,
I have some issues to use the Amazon Redshift connector to reach my Serverless Redshift instance.
My instance is well reachable through a database client (ex dbeaver), but not with the connector.
When I try to connect it, I have the following error:
Sorry, we encountered an error and were unable to complete your request.
The request returns an 400 HTTP error with the following reason error: JDBC_HOST_NOT_REACHABLE
Has anyone ever had the same problem?
Thanks for advance for your help and support 🙂
Solved! Go to Solution.
Ok we found a solution. We must enable the SSL and use the file downloaded here https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-ssl-support.html
The connector asks for a .pem file, but you have to fill out with the .crt downloaded on the above link
Ok we found a solution. We must enable the SSL and use the file downloaded here https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-ssl-support.html
The connector asks for a .pem file, but you have to fill out with the .crt downloaded on the above link
Thanks @webfacto for coming through with a solution!
@webfacto thanks! you saved me hours!