source_name_tag_based_masking_policies_set.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
SET TAG dp_governance.tags.tag_name = 'source-name';

ALTER TABLE IF EXISTS database_name.schema_name.table_name
MODIFY COLUMN column_name_2
SET TAG dp_governance.tags.tag_name = 'source-name';

ALTER TABLE IF EXISTS database_name.schema_name.table_name  
MODIFY COLUMN column_name_3
SET TAG dp_governance.tags.tag_name = 'source-name';