LIST SECRETS

Syntax

{ LIST | SHOW } SECRETS;

Description

This provides a list of Secrets that the user has access to.

Secrets will only be listed if the current role has USAGE privileges.

Examples

List Stores

The following provides a list of Secrets the current user has access to:

demodb.public/msk_public# LIST SECRETS;
      Name     | Access Region | Status |      Created at      |    Updated at                   
---------------+---------------+--------+----------------------+-----------------------
     my_secret | AWS us-east-1 | READY  | 2023-12-31T13:30:19Z | 2023-12-31T13:31:19Z