LIST SECRETS

Syntax

[ LIST | SHOW ] SECRETS;

Description

This provides a list of secrets to which the user has access.

Secrets are listed only if the current role has USAGE privileges.

Examples

List stores

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

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 |
+--------------+----------------+---------------------------------+----------------+---------+----------+-------------------------------+-------------------------------+