DELETE_LABEL

Stored procedure DELETE_LABEL is a Snowflake stored procedure written in Python that is used to construct a label object. This procedure is defined in database SUNDECK (database where Snowflake NativeApp is installed) schema ADMIN.

ACCOUNTADMIN privilege is required to run this stored procedure.

See also:: CREATE_LABEL, UPDATE_LABEL, SHOW PROCEDURES, DESCRIBE PROCEDURE

Syntax

DELETE_LABEL(<name>)

Arguments

<name>: a string that represents label name to delete.

Returns

NULL: if label was successfully deleted.
<error>: error message string in the case of failure to delete label.

Example:

nori#COMPUTE_WH@SUNDECK.(no schema)>call ADMIN.DELETE_LABEL('new_name');
+--------------+                                                                
| DELETE_LABEL |
|--------------|
| NULL         |
+--------------+
1 Row(s) produced. 

nori#COMPUTE_WH@SUNDECK.(no schema)>select * from catalog.labels where name = 'new_name';
+------+------------+------------+------------------+-----------+---------+-------------------+------------+
| NAME | GROUP_NAME | GROUP_RANK | LABEL_CREATED_AT | CONDITION | ENABLED | LABEL_MODIFIED_AT | IS_DYNAMIC |
|------+------------+------------+------------------+-----------+---------+-------------------+------------|
+------+------------+------------+------------------+-----------+---------+-------------------+------------+
0 Row(s) produced.