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 NameData TypeDescription
oauth_client_secret_2BASE64Secondary client secret for the specified integration. Snowflake supports two client secrets to allow for uninterrupted rotation.
oauth_client_secretBASE64Client secret for the specified integration
oauth_client_idSTRINGClient ID in Snowflake

Examples

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

select system$show_oauth_client_secrets('MYINT');