By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Connect to Redshift using Microsoft Azure AD

0

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?

Topics
AnalyticsDatabase
Tags
AnalyticsDatabaseAmazon Redshift
Language
English
rePost-User-2795963
asked 10 months ago865 views
1 Answer
-1

If not already done, then make sure you are using the latest Redshift drivers.

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.

profile pictureAWS
MilindOke
answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content