ALTER TABLE finance.customers SET TBLPROPERTIES (
'uc.owner'='[email protected]',
'uc.sensitivity'='restricted',
'uc.pii'='email,phone',
'uc.purpose'='inference',
'uc.retention_days'='365'
);
CREATE OR REPLACE FUNCTION mask_email(e STRING) RETURNS STRING
RETURN CASE
WHEN is_account_group_member('pii_readers') THEN e
ELSE regexp_replace(e, '(^.).+(@.+)$', '\\1***\\2')
END;
SELECT CASE
WHEN eval.f1 >= 0.80
AND NOT EXISTS (SELECT 1 FROM training_sources WHERE sensitivity IN ('restricted'))
THEN 'ALLOW' ELSE 'BLOCK' END AS gate_result;
{
"taxonomy_version": "1.0",
"labels": {
"sensitivity": ["public", "internal", "confidential", "restricted"],
"pii": ["none", "name", "email", "phone", "address", "government_id"],
"purpose": ["training", "eval", "inference", "monitoring", "analytics"],
"retention_days": [30, 90, 365, 1825],
"owner": ["[email protected]"],
"risk_level": ["low", "medium", "high"]
}
}