Column Level Security In Snowflake | Dynamic Data Masking In Snowflake

Video Description

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.