Snowflake - Dynamic Data Masking - Working Session

[@m.s.krishnamurthykitta]

love u bro for ur great explanation about concept end to end

[@harinimmagadda14]

awesome and ultimate explanation.. the way of explanation is excellent.
can you do video on end-to-end ETL workflow of snowflake.

[@pratikthole2414]

Masking Policies -
Protect Access to sensitive information from unauthorized users and allow access to authorized users. Its Schema Level object .At Actual storage level its stored as it is but while fetching and displaying masking policies applied over it . Can include conditions and functions to transform data when conditions are met. Can be applied on multiple columns .
Role Based
Create masking policy Policy_1 as (Cloumn_1 Datatype) returns Datatype⇒ Case When CURRENT_ROLE in (’ROLE_1’) T hen Column_1 else ‘****’ end ;
Condition Based
Create masking policy Policy_1 as (Cloumn_1 Datatype, Column_2 Datatype) returns Datatype⇒ Case When CURRENT_ROLE in (’role_1’) Then Column_1 when column_2=’ABC then Column_1 else ‘****’ end ;
Application -
ALTER TABLE TABLENAME MODIFY COLUMN COLUMN_1 SET MASKING POLICY POLICY_1 , MODIFY COLUMN COLUMN_2 SET MASKING POLICY POLICY_2 USING(COLUMN_1, COLUMN_2) ;
UNSET -To Remove ;
ALTER MASKING POLICY POLICY_NAME RENAME TO NEW_POLICY_NAME;
ALTER MASKING POLICY POLICY_NAME SET BODY ⇒ CASE STATEMENT ;
DROP MASKING POLICY POLICY_NAME;
Before Dropping we need to unset masking policy and datatype of input and output values must be same .

[@praveenaganesh9251]

Can you please upload videos on how to do data profiling and data cleansing in snowflake. Thanks for sharing your knowledge

[@mrjana520]

Hi, even I never did profiling and cleansing in snowflake

[@rakshithkrishna7393]

Nice. Could you please make a video on Row Level security policy?

[@mrjana520]

We can provide row level security by using views, already there is a video on my channel

[@deepthikotipalli]

sir what is the difference between tokenization and dynamic data masking.

[@mrjana520]

It is a vast topic, can't explain in 2 to 3 line, go through below link, it is well explained in Snowflake documentation.
docs.snowflake.com/en/user-guide/security-column-intro

[@rameshram1117]

hi sir , masking policy account admin role create chesa , aa table fetch chestunte account admin ki kuda mask avutundi and ye roles ki aithe display avvalo aa roles case statement rasi icham aa roles ki kuda mask aipotundi i mean authorised roles ki kuda mask avutundi and owner role ki kuda mask avutundi. okasari snowsight lo try cheyandi sir meeru cheppindi classic console kada , leda trail account masking policy lu work avvava?

[@mrjana520]

share the code of your policy creation statement.
I have shown here right with examples, there will be no change between classic and snowsight..

[@rameshram1117]

@@mrjana520 nenu chinna mistake chesa sir case statement compulsory ga upper case lo rayali appude work avutundi .but ippudu kuda poorti ga problem solve avaledu. Account admin role nunchi policy create chesa. Authorised roles ki visibility access icha but policy owner I mean account admin ki kuda mask avutundi . Account admin i mean policy owner aa data ni chudalante ela ani ardham avvatledu sir please konchem chepthara

[@mrjana520]

account admin role grant chesina user ku kuda access ivvu policy lo

[@rameshram1117]

Grant usage on accountadmin to user RAMESHRAM ; anthena sir command

[@mrjana520]

Brother pls dont waste others time, I have clearly explained all these roles, users, access policies in my videos, please watch them, they don't even take 1 hour.

[@Grow-spher]

i want snowflake videos pleaseee

[@mrjana520]

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for just 499 rupees.. I will be updating this content and will be uploading all new videos in this course.
My Snowflake Udemy Course:
www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=0D096876AA7A5A91FBCD
Use the coupon below to get a discount on my course.
Coupon: 0D096876AA7A5A91FBCD

[@harish2996]

Sir please provide your mailid

[@mrjana520]

I can be reachable on [e-mail]