Applying an object tag
Claro's compliance officer has asked the data team to tag the email column in CORE.USERS so it surfaces in governance reports and can feed into downstream masking policy decisions. A sensitivity tag with allowed values 'PII', 'INTERNAL', and 'PUBLIC' has already been created in the CORE schema. Your task is to apply it to the email column with a value of 'PII'.
Diese Übung ist Teil des Kurses
<Kurs>Snowflake Management, Governance & Collaboration</Kurs>Übungsanweisungen
- Use
ALTER TABLE ... MODIFY COLUMN ... SET TAGto apply thesensitivitytag to theemailcolumn inCORE.USERSwith a value of'PII'.
Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
ALTER TABLE CORE.USERS
MODIFY COLUMN ___ SET TAG ___.___ = '___';