Uploaded April 2024 | Updated September 2026, 1 hour ago
We're all familiar with the Dynamic Data Masking policy, but there's another crucial feature in Snowflake that enables the masking of sensitive table data based on certain conditions. Therefore, the focus of this chapter is on how to develop and implement conditional data masking, associating it with a table column. In this short tutorial, we'll cover everything about conditional data masking.
This tutorial goes beyond SQL syntax and focuses all all the important aspects of conditional dynamic data masking concepts, 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 simple and conditional data dynamic masking?
2. How to build conditional data masking policy?
3. How to use the keyword USING to enable the conditional masking.
🚀🚀 Data Engineering Simplified - Social Links
instagram.com/learn_dataengineering - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
facebook.com/groups/627874916138090 - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
medium.com/@data-engineering-simplified/5b2f8b199654
🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:11 Welcome Note
➥ 01:46 Use Case & Data Analysis
➥ 03:59 Data Loading
➥ 07:56 Conditional Masking SQL
➥ 11:40 Policy Reference - Account Usage View
➥ 12:50 Special Section
➥ 13:43 Thank You Note
🚀🚀 Dynamic Data Masking Playlist
-----------------------------------------------------------
Part-01 Dynamic Data Masking youtu.be/7YKQuKKcruo
Part-02 Conditional Masking Policy youtu.be/l5zZPSsWTkQ
Part-03 Tag Based Masking Policy 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.
We're all familiar with the Dynamic Data Masking policy, but there's another crucial feature in Snowflake that enables the masking of sensitive table data based on certain conditions. Therefore, the focus of this chapter is on how to develop and implement conditional data masking, associating it with a table column. In this short tutorial, we'll cover everything about conditional data masking.
This tutorial goes beyond SQL syntax and focuses all all the important aspects of conditional dynamic data masking concepts, 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 simple and conditional data dynamic masking?
2. How to build conditional data masking policy?
3. How to use the keyword USING to enable the conditional masking.
🚀🚀 Data Engineering Simplified - Social Links
instagram.com/learn_dataengineering - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
facebook.com/groups/627874916138090 - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
medium.com/@data-engineering-simplified/5b2f8b199654
🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:11 Welcome Note
➥ 01:46 Use Case & Data Analysis
➥ 03:59 Data Loading
➥ 07:56 Conditional Masking SQL
➥ 11:40 Policy Reference - Account Usage View
➥ 12:50 Special Section
➥ 13:43 Thank You Note
🚀🚀 Dynamic Data Masking Playlist
-----------------------------------------------------------
Part-01 Dynamic Data Masking youtu.be/7YKQuKKcruo
Part-02 Conditional Masking Policy youtu.be/l5zZPSsWTkQ
Part-03 Tag Based Masking Policy 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.
