DROP DESCRIPTOR_SOURCE

Syntax

DROP DESCRIPTOR_SOURCE descriptor_source_name;

Description

Permanently removes all Descriptors that were imported from a Descriptor Source.

DROP DESCRIPTOR_SOURCE cannot be undone. Use it with care!

Arguments

descriptor_source_name

Name of the Descriptor Source to remove of its corresponding descriptors. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Examples

Drop a Descriptor Source

The following demonstrates that when the Descriptor Source pageviews is dropped, the descriptors pageviews.PageviewsKey and pageviews.Pageviews that were extracted from it are also removed from the system:

demodb.public/demostore# LIST DESCRIPTORS;
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
|  Name      |  Source Name |  Type      |  Owner     |  Created At                   |  Updated At                   |
+============+==============+============+============+===============================+===============================+
| StaffKey   | employee     | protobuf   | sysadmin   | 2024-06-04 20:46:44 +0000 UTC | 2024-06-04 20:46:44 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Manager    | employee     | protobuf   | sysadmin   | 2024-06-04 20:46:44 +0000 UTC | 2024-06-04 20:46:44 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Employee   | employee     | protobuf   | sysadmin   | 2024-06-04 20:46:44 +0000 UTC | 2024-06-04 20:46:44 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
| Address    | employee     | protobuf   | sysadmin   | 2024-06-04 20:46:44 +0000 UTC | 2024-06-04 20:46:44 +0000 UTC |
+------------+--------------+------------+------------+-------------------------------+-------------------------------+
demodb.public/demostore# DROP DESCRIPTOR_SOURCE employee;
+-------------------+------------+------------+------------------------------------------+
|  Type             |  Name      |  Command   |  Summary                                 |
+===================+============+============+==========================================+
| descriptor_source | employee   | DROP       | descriptor source "employee" has been    |
|                   |            |            | deleted                                  |
+-------------------+------------+------------+------------------------------------------+
demodb.public/demostore# LIST DESCRIPTORS;
+------------+--------------+------------+------------+-------------+-------------+
|  Name      |  Source Name |  Type      |  Owner     |  Created At |  Updated At |
+============+==============+============+============+=============+=============+
+------------+--------------+------------+------------+-------------+-------------+