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>' )
Copy

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');
Copy