Connect to Redshift using Microsoft Azure AD

Question

Hello,

I want to be able to connect to a Redshift cluster using Microsoft Azure AD as SSO.

We've followed the steps here:
https://aws.amazon.com/blogs/big-data/integrate-amazon-redshift-native-idp-federation-with-microsoft-azure-ad-using-a-sql-client/

As a SQL Client, I'm using DataGrip.

When I add all the details and test the connection, a web page opens that says "Thank you for using Amazon Redshift! You can now close this window.". When I go back to DataGrip, there's an error "JWT error: com.amazon.redshift.plugin.InternalPluginException: No valid code found".

Can anyone help?

Answer

If not already done, then make sure you are using the latest [Redshift drivers](https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html).

The blog shows client setup for `DBeaver` and `SQL Workbench/J` but every client can have its own way of setting up. Firstly confirm with DataGrip that it supports this integration and then make sure you are able to set the client side settings.

Connect to Redshift using Microsoft Azure AD

Contenus pertinents