Schema:: ACCOUNT_USAGE

SECRETS view¶

This Account Usage view provides the secrets in your account.

Each row in this view corresponds to a different secret.

Columns¶

Column Name	Data Type	Description
`id`	NUMBER	Internal, system-generated identifier for the secret.
`name`	VARCHAR	Name of the secret.
`schema_id`	NUMBER	Internal, system-generated identifier for the schema of the secret.
`schema`	VARCHAR	Schema that the secret belongs to.
`database_id`	NUMBER	Internal, system-generated identifier for the database of the secret.
`database`	VARCHAR	Database that the secret belongs to.
`owner`	VARCHAR	Name of the role that owns the secret; NULL if it has been dropped.
`owner_role_type`	VARCHAR(13)	The type of role that owns the object, either `ROLE` or `DATABASE_ROLE`. . If a Snowflake Native App owns the object, the value is `APPLICATION`. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.
`secret_type`	VARCHAR	The type of secret (`GENERIC_STRING`, `OAUTH2`, or `PASSWORD`).
`oauth_access_token_expiry_time`	TIMESTAMP_LTZ(6)	The expiry time of the OAuth access token stored in the secret.
`oauth_refresh_token_expiry_time`	TIMESTAMP_LTZ(6)	The expiry time of the OAuth refresh token stored in the secret.
`oauth_scopes`	VARCHAR	A comma-separated list of scopes to use when making a request from the OAuth server by a role with USAGE on the integration during the OAuth client credentials flow.
`api_authentication_integration`	VARCHAR	The name of the API Authentication Integration used by this secret for authentication.
`comment`	VARCHAR	Comment for the secret.
`created_on`	TIMESTAMP_LTZ(6)	Date and time when the secret was created.
`last_altered_on`	TIMESTAMP_LTZ(6)	Date and time when the secret was last altered.
`deleted_on`	TIMESTAMP_LTZ(6)	Date and time when the secret was dropped.

Usage Notes¶

Latency for the view may be up to 120 minutes (2 hours).
Sensitive values that the secret stores, such as the values for username, password, and OAuth refresh token, are not reported in this view.