Role, Grants & Role Hierarchy In Snowflake | Chapter-20 | Snowflake Hands-on Tutorial

[@mukeshims09]

I have recently cleared my SNOWPRO CORE Certification and your videos helped me a lot to getting understanding basics of SNOWFLAKE. Thanks for preparing and sharing a wonderful study material.

[@DataEngineering]

Great to hear and congratulation... happy to hear that these content help to some extend for your exam preparation.

[@srinivassahu5261]

Thanks for these lesson. This help me for Snowflake Pro certification. I am HAPPY to Share that I CLEAR SNOWFLAKE PRO CERTIFICATION !!!! . I didn't took any training or buy any ONLINE Q&A dumps. Thanks a Lot

[@DataEngineering]

Congratulation Srinivas.. thanks for your note..

[@kushalthakur0011]

Thanks, buddy, As a fresher in the data engineering field your videos helped me a lot. ❣❣❣

[@lavesh90]

The most Comprehensive, Crisp with gist on hands-on, Beautiful, Clear cut explanation on one of the most tricky topics of Database realm ❤ Kudos to the your effort and expertise sir🎉

[@DataEngineering]

Glad it was helpful!

[@singh_abhishek1429]

This is again one of the best lesson done by you. it is pretty easy to get confuse between DAC and RBAC. You explained very well and I was able to relate with my work. Thank you for helping us out.

[@DataEngineering]

Glad you enjoyed it!

[@pundrikaxhtripathi]

best video on Snowflake role and user concept. thank you so much for sharing such a vast topic in small video. makes my life much easier now.

[@DataEngineering]

Glad it was helpful!

[@kirankumar1290]

Excellent Presentation!!! I would like to Thank you very much such Informative session.

[@DataEngineering]

Glad it was helpful! You can also try to see my udemy courses that has full code + sql scripts and they are real life scenario based contents. 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/ 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/ 3. www.udemy.com/course/snowflake-dynamic-table-masterclass-e2e-data-pipeline/?couponCode=B1E84B2CB4AA82CB95E3

[@pratik5648]

Great Explanation

[@DataEngineering]

Glad it was helpful! Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@annahopp]

Very useful.

[@tableaututorialstips71]

HI Sir Here I have q question SECURITYADMIN is given to DE_PM_ROLE so other roles also we can give directly SECURITYADMIN right instead of assigning like this DE_DEV_TEAM-->DE_PM_ROLE here instead of DE_PM_ROLE role why we are not assigning SECURITYADMIN

[@jk17]

Hi, Thanks for the video. This is very helpful. I have a use case where we have 2 custom roles ROLE1 and ROLE2. These are created for different sets of users to manage.Users in both the roles have access to create, drop, insert, update, delete, select tables/views etc in a database DB1. How can we configure them so that any tables or views created by any role is accessible to other role too. Both roles should have access to do any changes i,e, create, drop, insert, update, delete etc. Please help in this.

[@DataEngineering]

For that you have to use future concepts...

[@jk17]

@@DataEngineering but in that case won’t the ownership of the objects will be an issue?

[@srinivasp6579]

Could you please let me know how do we setup ETL flow among Dev,tst and prod environments? How do we Maintain Code versioning? Best tools for version control? Does Snowflake have in built version mechanism?

[@rajeshg3810]

Excellent session ,thanks

[@DataEngineering]

Glad you enjoyed it

[@pulakhazra2692]

Great content! Is there any video explaining row and column level security?

[@DataEngineering]

I have not really created any content on row level & column level security. Thanks for this request.. will plan for it You can download this master cheat sheet, that can help you to identify which all topics and sub-topics are covered under different playlist and different videos. 🚀🚀 Cheat Sheets 🚀🚀 ➥ Complete Snowflake Tutorial rebrand.ly/maj4l6x ➥ Complete Snowflake JSON Guide rebrand.ly/d52cef

[@metalurgixinc.8113]

I am looking for something like this as well, specifically around protecting PII data when it is in a table with other non-PII data.

[@srujanchinnu6430]

HI... your explanation was too good and easy to gain snowflakes knowledge , would you please upload the rest 5 classes to learn the course completely. Thanks

[@DataEngineering]

working on it.. will be published soon

[@shailendravernekar2389]

Thank you so much ...... very informative video

[@DataEngineering]

So nice of you

[@divymistry8737]

Thanks 🙂

[@DataEngineering]

Welcome 😊

[@willywooca]

Hi, thanks for the video! I have one question, in your example, why are you creating all the custom roles under SECURITYADMIN? It thought all custom roles should be created under SYSADMIN role?

[@DataEngineering]

All roles must be created using security admin profile.... other roles also allow to do that.. but it is good to have security admin role for it.

[@willywooca]

@@DataEngineeringThanks, I have another question. In your example, QA is inherited by Analyst role, so in theory all privileges in QA, the Analyst role should already have, why do you need to assign those privileges again @34:32?

[@anilkumarm2943]

Thank you much, The notes link isn't working

[@saranshchoudhary399]

Hi Buddy, Very good videos Waiting for the ch 21 to 25...

[@DataEngineering]

Coming soon

[@thamilkadavarayar6707]

Another good video.

[@DataEngineering]

Thanks again! and glad you enjoyed this.. you can also try following .. many folks think they know a lot .. but lot more are hidden in these 3 videos (if seen, then ignore my msg) ➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 kzbin.info/www/bejne/eaSrY6Z4a8yqotk ➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐kzbin.info/www/bejne/rp_NdJWdqpWEoJY ➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 kzbin.info/www/bejne/aKTShayYhL-ejrs

[@Dinesh-xj6ei]

Hello, Custom roles has to be assigned to SYSADMIN right? You are assigning those to SECURITYADMIN?

[@DataEngineering]

not necessarily and it all depends on your role design...

[@anantababa]

Are you providing live training?

[@DataEngineering]

not now.. may be in future.. pls follow me in instagram..

[@TechCoach]

Great Video as always, Any way I can reach out to you ( over an email or LinkedIn?)

[@chaitanyakrishna5873]

Can we grant role access to another role.. instead of using secondary role ALL..

[@DataEngineering]

Yes, you can do it... role can be granted to another role as well as anothe user too.

[@saisindhugurram9834]

Users can also be created with useradmin right?

[@DataEngineering]

yes.. right..

[@raghum6808]

Thanks for the info.. which role can be used for creating user either SECURITY ADMIN/USERADMIN/ACCOUNTADMIN.. Because ACCOUNT and SECURITY ADMIN are the roles (8:48 ) who can create the user but 26.11 , we can user by using USERADMIN role .. Could you please clarify..Thanks in Advance..

[@DataEngineering]

Yes, you are right.. USERADMIN is dedicated to user and role management only. Is granted the CREATE USER and CREATE ROLE security privileges & Can create users and roles in the account.

[@raghum6808]

@@DataEngineering Thanks for the clarification..

[@raghum6808]

IF possible could you please do video on ORGADMIN role.. Please

[@DataEngineering]

@@raghum6808 Sure, will do as separete video and not part of this playlist. Thanks for your note.

[@DataEngineering]

@@raghum6808 Welcome

[@radhikamalpani2927]

Is it necessary to learn informatica powercenter before learning snowflake?

[@joshipodili6210]

Not Needed,SQL is prerequisite for learning the SNOWFLAKE

[@DataEngineering]

Any data and SQL backgroud is good enough to learn snowflake. Even a non data background can work in snowflake.

[@srinivassahu5261]

Thanks for these lesson . Could you please share links for chapter 21 to 25 ?

[@DataEngineering]

working on it.. will relase soon.. one is coming this weekk

[@marvinpriester3024]

Where is it possible to see the hierarchy like that 25:30 at your own account?

[@DataEngineering]

yes, it is possible. You must have appropriate privilege in your snowflake acccount Here is the flow to get into the screen.. Snowsight (Role:Accountadmin) >> Left Pane >> Admin Menu >> Users & Roles Sub-Menu >> Roles Tab (from main canvas) ... Snowflake has been changing snowsight quite a lot.

[@kusumamathi9812]

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it? Can one answer the above question? ( My confusion here is about the ownership, I guess role will have all ownership privileges rather than user , So can anyone confirm on the same)

[@DataEngineering]

it is owned by the role ( select current_role) and not to the user.

[@sushmamanagundi366]

Thankyou for very informative vedios on Snowflake. I'm attempting Snowpro certification exam on Apr 11. Your vedios are helping alot. May I know your linkedin account name?

[@DataEngineering]

All the best for your exam and I feel good that this content is helping community and setting them for success. If you have any specific query regarding snowflake, I can also be reached out via instagram (instagram.com/learn_dataengineering/)

[@singh_abhishek1429]

Good luck for the exam !!

[@Buzzingfact]

Hi Sushma, what tools you are using for migrating data from Teradata to snowflake?

[@mahak39]

Hi sir.The videos are amazing.when can i expect next chapter?

[@mahak39]

Can anyone provide the information.

[@DataEngineering]

Will upload soon

[@ashishpatil9023]

awsome. sir where is link for chapters after 20

[@DataEngineering]

Ch-21 is on way.. follow this space.. going to be release this week..

[@LaxmanKumar-zf4sc]

Can you pls share the commands

[@ashishpatil6174]

Link for chapter 21 onwards pls

[@DataEngineering]

going to be release this week... so watch this space...