Categories:
System Functions (System Information)

SYSTEM$SHOW_OAUTH_CLIENT_SECRETS

Returns the client secrets in a string. The client ID and a client secret must be included in the authorization header to the OAuth token endpoint.

Syntax

SYSTEM$SHOW_OAUTH_CLIENT_SECRETS( '<integration_name>' )

Arguments

integration_name
Name of the integration. Note that the integration name is case-sensitive and must be uppercase and enclosed in single quotes.

Output

The function returns the following elements in a JSON object:

Column Name Data Type Description
oauth_client_secret_2 BASE64 Secondary client secret for the specified integration. Snowflake supports two client secrets to allow for uninterrupted rotation.
oauth_client_secret BASE64 Client secret for the specified integration
oauth_client_id STRING Client ID in Snowflake

Examples

The following example retrieves the client secret for the specified integration:

SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('myint');