DESC IDENTITY PROVIDER - Amazon Redshift
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

DESC IDENTITY PROVIDER

Displays information about an identity provider. Only a superuser can describe an identity provider.

Syntax

DESC IDENTITY PROVIDER identity_provider_name

Parameters

identity_provider_name

The name of the identity provider.

Example

The following example displays information about the identity provider.

DESC IDENTITY PROVIDER azure_idp;

Sample output.

uid | name | type | instanceid | namespc | params | enabled --------+-----------+-------+--------------------------------------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------- 126692 | azure_idp | azure | e40d4bb2-7670-44ae-bfb8-5db013221d73 | aad | {"issuer":"https://login.microsoftonline.com/e40d4bb2-7670-44ae-bfb8-5db013221d73/v2.0", "client_id":"871c010f-5e61-4fb1-83ac-98610a7e9110", "client_secret":'', "audience":["https://analysis.windows.net/powerbi/connector/AmazonRedshift", "https://analysis.windows.net/powerbi/connector/AWSRDS"]} | t (1 row)