- Newest
- Most votes
- Most comments
Hello, considering the Profile is configured for "user2" in the credentials file , the example URL that you have provided should be able to connect to Redshift using IAM credentials ( provided your other connectivity setup is correct). Basically, once all the supplied parameters are valid, the driver will call the GetClusterCredentials using those values. Firstly, please ensure you are using a JDBC driver that supports IAM authentication [4]. Additionally, to rule out if the issue is not specific to IAM authentication , can you also try to establish connection using native database user and see if it’s working. If that doest work as well, then probably it can be more related to general connectivity which can also be troubleshooted using resources available here [1][2][3] If that is not the case, then I would recommend to create a support case with Redshift support team as we would need to understand more details pertaining to your cluster and error that you are facing.
References [1] https://docs.aws.amazon.com/redshift/latest/mgmt/troubleshooting-connections.html [2]https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-to-cluster.html [3] https://docs.aws.amazon.com/redshift/latest/mgmt/configuring-connections.html [4]https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html
I was trying to put a comment, but it doesn't accept images
One other thing. I was able to establish the connection from SQLWorkbench from windows. But trying to set those on dBeaver did not work on Windows or Mac. I also could not get it to work on SQLWorkbench on Mac as ADFSCredentialsProvider is not supported on Mac
How could I translate the above to Mac - as I need Mac equivalent of the ADFSCredentialsProvider?
Any help in this regard is appreciated.
In the meantime, I will go through above links and to try and resolve the issue
Relevant content
- asked a year ago
- asked 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
Has anyone done this? Is it possible?