AWS announces preview of AWS Interconnect - multicloud

AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.

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?

Topics: Analytics Database
Tags: Analytics Amazon Redshift Database
Language: English

rePost-User-2795963

asked 2 years ago2.1K views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

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

EXPERT

MilindOke

answered 2 years ago

rePost-User-2795963
2 years ago
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 EXPERT
2 years ago
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?

Relevant content

Redshift connection via Microsoft account needs Amazon resource name
Raunak
asked 2 years ago
AWS Glue JDBC connection to Azure managed SQL Server using Azure Active Directory - Password authentication
Accepted Answer
Jean-Francois
asked 2 years ago
AppFlow SharePoint OAuth Error: AADSTS50011 with custom Azure AD app despite correct redirect URI
Wissam
asked 5 months ago
How can I connect Microsoft Access to Amazon Redshift?
Accepted Answer
rePost-User-4545052
asked 2 years ago
How do I set up an Active Directory to manage and configure WorkSpaces?
AWS OFFICIALUpdated a year ago
How do I configure a Site-to-Site VPN connection with dynamic routing between AWS and Azure?
AWS OFFICIALUpdated 3 months ago
How do I restore an encrypted backup file or encrypted Microsoft Azure backup in RDS for SQL Server from an on-premises environment?
AWS OFFICIALUpdated 3 years ago
How do I restore an encrypted backup file or encrypted Microsoft Azure backup in RDS for SQL Server from an on-premises environment?
AWS OFFICIALUpdated a year ago
Converting spatial buffer operation from Azure SQL to Amazon Redshift
EXPERT
RiteshKSinha
published 10 months ago
Migrating Workloads using VMware vCenter Converter Standalone– P2V, V2V and C2C
EXPERT
Amit Kumar Jha
published 2 years ago

Connect to Redshift using Microsoft Azure AD

Add your answer

Relevant content