source_name_tag_based_masking_policies_unset.sql

-- Devlopment
USE ROLE dp_owner_dev;

/*

Table: schema_name.table_name

Columns:
column_name_1
column_name_2
column_name_3

*/  

ALTER TABLE IF EXISTS database_name.schema_name.table_name
MODIFY COLUMN column_name_1 
UNSET TAG dp_governance.tags.tag_name;

ALTER TABLE IF EXISTS database_name.schema_name.table_name 
MODIFY COLUMN column_name_2 
UNSET TAG dp_governance.tags.tag_name;

ALTER TABLE IF EXISTS database_name.schema_name.table_name  
MODIFY COLUMN column_name_3 
UNSET TAG dp_governance.tags.tag_name;