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
www.instagram.com/learn_dataengineering/ - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
www.facebook.com/groups/627874916138090/ - Join Exclusive Snowflake Facebook Group

🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
medium.com/@data-engineering-simplified/5b2f8b1996…

🚀🚀 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    • Column Level Security In Snowflake | ...  
Part-02 Conditional Masking Policy    • What Is Conditional Dynamic Data Mask...  
Part-03 Tag Based Masking Policy    • Tag Based Dynamic Data Masking In Sno...  









#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 Snowfla