Amazon Redshift Connector cannot Authenticate

Anthony_Wang

We are trying to connect to a client's Redshift environment. IPs have been whitelisted on their side. But we are still getting an Authentication error. I've got a screenshot of the configuration page.

Billobi

Hi Anthony, did you ever get this one figured out? (no screenshot was attached)

There are a solid handful of settings that need to be handled properly. Did your Redshift DBA review all of the steps in the power up guide? Was SSH identified if needed? Best advice is to double check each component of the setup and try to mimic everything that works in the Amazon Redshift Console.

I've been lucky enough to have assistance from some good DBAs who configured the Redshift environments that I've connected to...definitely takes persistence & attention to detail.

https://domo-support.domo.com/s/article/360043436053?language=en_US

https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-to-cluster.html

https://www.dundas.com/support/learning/documentation/connect-to-data/how-to/connecting-to-amazon-redshift#:~:text=Sign%20in%20to%20your%20AWS,to%20get%20your%20connection%20string.