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;
LIST SECRETS;
+--------------+----------------+---------------------------------+----------------+---------+----------+-------------------------------+-------------------------------+
|  Name        |  Type          |  Description                    |  Access Region |  Status |  Owner   |  Created At                   |  Updated At                   |
+==============+================+=================================+================+=========+==========+===============================+===============================+
| my_secret    | generic_string | This is a generic_string secret | AWS us-east-1  | ready   | orgadmin | 2024-07-18 18:24:37 +0000 UTC | 2024-07-18 18:24:38 +0000 UTC |
+--------------+----------------+---------------------------------+----------------+---------+----------+-------------------------------+-------------------------------+
| an_api_token | generic_string | A secret for my API comms       | AWS us-east-1  | ready   | orgadmin | 2024-07-18 18:26:38 +0000 UTC | 2024-07-18 18:26:40 +0000 UTC |
+--------------+----------------+---------------------------------+----------------+---------+----------+-------------------------------+-------------------------------+