Hi,
We wish to use Redshift’s native IDP support for Azure AD SSO. The Url we use is something like this:
jdbc:redshift://{host}:5439/{database}?plugin_name=com.amazon.redshift.plugin.BrowserAzureOAuth2CredentialsProvider;scope=api://{scope}/jdbc_login;listen_port=7890;client_id={client_id};idp_tenant={tenant}
Reference documentation here: Integrate Amazon Redshift native IdP federation with Microsoft Azure AD and Power BI | AWS Big Data Blog
Thanks,
Chris