LIST DESCRIPTORS

Syntax

[ LIST | SHOW ] DESCRIPTORS
[ IN DESCRIPTOR_SOURCE descriptor_source_name ];

Description

Descriptors are used for supporting protocol buffers. Creating a descriptor source enables users to associate ProtoBuf descriptors with specific entities for data serialization and deserialization. This command provides a list of descriptors that the user has access to in the current organization. Descriptors are created when descriptor sources are created with CREATE DESCRIPTOR_SOURCE.

This command provides a list of descriptors, optionally filtered by a specific descriptor source.

Descriptors are listed only if the current role has USAGE privileges on the descriptor source.

Arguments

descriptor_source_name

Optionally, this lists the descriptors belonging to the specified descriptor source.

Examples

List all descriptors

demodb.public/demostore# LIST DESCRIPTORS;
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
|  Name      |  Source Name |  Type      |  Owner     |  Created At                   |  Updated At                   |
+============+==============+============+============+===============================+===============================+
| Message2   | src1         | protobuf   | sysadmin   | 2024-06-03 16:59:52 +0000 UTC | 2024-06-03 16:59:52 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Message1   | src1         | protobuf   | sysadmin   | 2024-06-03 16:59:52 +0000 UTC | 2024-06-03 16:59:52 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| StaffKey   | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Manager    | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Employee   | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Address    | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+

List all descriptors from a descriptor source

From a list of all available descriptors, you can choose one of the descriptor source names — for example, employee — and list only the descriptors imported using that source:

demodb.public/demostore# LIST DESCRIPTORS IN DESCRIPTOR_SOURCE employee;
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
|  Name      |  Source Name |  Type      |  Owner     |  Created At                   |  Updated At                   |
+============+==============+============+============+===============================+===============================+
| StaffKey   | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Manager    | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Employee   | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Address    | employee     | protobuf   | sysadmin   | 2024-06-04 19:03:51 +0000 UTC | 2024-06-04 19:03:51 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+