Skip to content

Instantly share code, notes, and snippets.

@zdravko-il

zdravko-il/masking-hash.sql

Last active December 8, 2023 15:19
Show Gist options
  • Save zdravko-il/794a867c28a516d422af9e8ec951b31e to your computer and use it in GitHub Desktop.
Save zdravko-il/794a867c28a516d422af9e8ec951b31e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
masking-hash.sql
CREATE MASKING POLICY hash_mask AS (val string) RETURNS string -> SHA2(val);
ALTER TABLE customer MODIFY COLUMN name SET MASKING POLICY hash_mask,
ALTER TABLE customer MODIFY COLUMN email SET MASKING POLICY hash_mask;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment