Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/unattach_masking_policie_from_tag_employee.sql

Last active July 7, 2024 09:40
Show Gist options
  • Save vvgsrk/5eaa77e491109475e7d9c74ee5348560 to your computer and use it in GitHub Desktop.
Save vvgsrk/5eaa77e491109475e7d9c74ee5348560 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
unattach_masking_policie_from_tag_employee.sql
USE ROLE TAG_ADMIN;
ALTER TAG dp_governance.tags.employee_sensitive
UNSET MASKING POLICY dp_governance.masking_policies.string_mask_employee,
MASKING POLICY dp_governance.masking_policies.float_mask_employee,
MASKING POLICY dp_governance.masking_policies.timestamp_mask_employee,
MASKING POLICY dp_governance.masking_policies.date_mask_employee,
MASKING POLICY dp_governance.masking_policies.number_mask_employee
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment