Column Level Security In Snowflake | Dynamic Data Masking In Snowflake

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
/ learn_dataengineering - Connect Via Instagram
/ data-engineering-simpl... - Read Medium Blog Pages For Articles
/ 627874916138090 - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
/ 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 • Column Level Security ...
Part-02 Conditional Masking Policy • What Is Conditional Dy...
Part-03 Tag Based Masking Policy • Tag Based Dynamic Data...
#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.

[@jk17]

Thanks for the video.
To implement more granular CLS, do we need to have masking policy for each table and column level for only PII columns?

[@Jobin70000gmail]

Can you please do a video on Dynamic table,hybrid table and iceberg Tables

[@DataEngineering]

Dynamic table is released as udemy course.
www.udemy.com/course/snowflake-dynamic-table-masterclass-e2e-data-pipeline/