Connect to Redshift using Microsoft Azure AD

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?

주제

분석 데이터베이스

태그

분석 데이터베이스 아마존 Redshift

언어

English

rePost-User-2795963

질문됨 10달 전906회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

-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.

MilindOke

답변함 10달 전

rePost-User-2795963
10달 전
I'm using the latest Redshift drivers.

To be sure, I've now tried also with DBeaver and the error is exactly the same. In both DataGrip and DBeaver I was able to set client side settings, which makes it open the webpage in the first place.
MilindOke
10달 전
Have you configured detailed logging. https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-configuring-logging.html

We you able to capture more details in the driver logs?

Connect to Redshift using Microsoft Azure AD

관련 콘텐츠