POST_START
Removing an Obsolete Governance Tag from a Production Table
I recently had to address an outdated governance tag on a production table in our data lake. The table, production.customers.customer_master, was marked with a legacy_classification tag that was no longer relevant. My task was to remove this tag and verify that it was successfully removed. I started by checking the current tags applied to the table.
DESCRIBE TABLE EXTENDED production.customers.customer_master;
| col_name | data_type | comment |
|---|---|---|
| customer_id | bigint | customer identifier |
| customer_name | string | customer display name |
| region | string | sales region |
I noticed that the table did not display any tags in the output, which was expected. However, I wanted to be certain that the legacy_classification tag was not silently present. I decided to run the ALTER TABLE command to unset the tag and see if it was actually applied.
ALTER TABLE production.customers.customer_master UNSET TAGS ('legacy_classification');
Command completed successfully; the requested catalog state change is now in effect.
The command returned a success message, confirming that the tag was removed. To be thorough, I ran the DESCRIBE TABLE EXTENDED command again to verify that the tag was no longer associated with the table.
DESCRIBE TABLE EXTENDED production.customers.customer_master;
| col_name | data_type | comment |
|---|---|---|
| customer_id | bigint | customer identifier |
| customer_name | string | customer display name |
| region | string | sales region |
I verified that the table no longer had the legacy_classification tag, and the output was consistent with what I expected. This process helped me understand how the Unity Catalog manages metadata tags and how to safely remove obsolete governance tags from production tables.
Leave a Reply