To safeguard PII (or PHI or Sensitive Information) column-data/fields, Snowflake has introduced a schema-level masking policy object. This object allows for column-level security and masking/obfuscation to protect sensitive data. This "Column Level Security (CLS) in Snowflake" video tutorial is a comprehensive guide to help snowflake data developers to understand how it can be achived using policy objects.
This tutorial delves beyond SQL syntax and examines all the significant aspects of dynamic data masking, facilitating column-level security in the Snowflake cloud data warehouse platform.
Once you complete this visual guided tour, you would be able to understand and answer following questions
1. Difference between static and dynamic masking?
2. How to apply column level masking in snowflake using masking policy?
3. How to re-use policy objects to mask one or more columns within and across the tables.
4. The data masking and impact on where clause?
5. Importance of context function when creating masking policies?
🚀🚀 Data Engineering Simplified - Social Links
https://www.instagram.com/learn_dataengineering/ - Connect Via Instagram
https://medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
https://www.facebook.com/groups/627874916138090/ - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
https://medium.com/@data-engineering-simplified/5b2f8b199654
🚀🚀 Chapters
--------------------------
➥
00:00 Introduction
➥
01:29 Welcome Note
➥
02:04 Use Case Explaination
➥
03:20 Live Example
➥
11:39 Masking Policy DDL
➥
14:30 DDM - Information Schema
➥
21:49 Alter Masking Policy
➥
26:39 Data Type Mismatch
➥
28:55 Where Clause Behaviour
➥
31:00 Special Section
➥
32:36 What Next
🚀🚀 Dynamic Data Masking Playlist
-----------------------------------------------------------
Part-01 Dynamic Data Masking
https://youtu.be/7YKQuKKcruo
Part-02 Conditional Masking Policy
https://youtu.be/l5zZPSsWTkQ
Part-03 Tag Based Masking Policy
https://youtu.be/80l8943gGk0
#snowflaketutorial
#columnlevelsecurity
#snowflake
#dataengineeringsimplifed
#DESimplified
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.