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.
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
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🎉
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
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.
You mentioned that only Accountadmin & securityadmin can create Users but at 26:10 minute you mentioned "as per snowflake recommendation use Useradmin to create Users" then created user I am bit confused.
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?
@@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?
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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
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
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..
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.
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.
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?
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
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.
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 🌐 th-cam.com/video/CsH2sB6gwlw/w-d-xo.html ➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐th-cam.com/video/xnjCbgu0Qj4/w-d-xo.html ➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 th-cam.com/video/2soTybOZkXY/w-d-xo.html
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?
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/)
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
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)
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.
Great to hear and congratulation... happy to hear that these content help to some extend for your exam preparation.
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
Congratulation Srinivas.. thanks for your note..
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🎉
Glad it was helpful!
Thanks, buddy, As a fresher in the data engineering field your videos helped me a lot.
❣❣❣
Excellent Presentation!!! I would like to Thank you very much such Informative session.
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
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.
Glad you enjoyed it!
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.
Glad it was helpful!
You mentioned that only Accountadmin & securityadmin can create Users but at 26:10 minute you mentioned "as per snowflake recommendation use Useradmin to create Users" then created user I am bit confused.
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?
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.
@@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?
Great Explanation
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
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Great content! Is there any video explaining row and column level security?
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
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.
Hello, Custom roles has to be assigned to SYSADMIN right? You are assigning those to SECURITYADMIN?
not necessarily and it all depends on your role design...
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..
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.
@@DataEngineering Thanks for the clarification..
IF possible could you please do video on ORGADMIN role.. Please
@@raghum6808 Sure, will do as separete video and not part of this playlist. Thanks for your note.
@@raghum6808 Welcome
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.
For that you have to use future concepts...
@@DataEngineering but in that case won’t the ownership of the objects will be an issue?
Excellent session ,thanks
Glad you enjoyed it
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?
Thank you so much ...... very informative video
So nice of you
Very useful.
Are you providing live training?
not now.. may be in future.. pls follow me in instagram..
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
working on it.. will be published soon
Where is it possible to see the hierarchy like that 25:30 at your own account?
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.
Thanks 🙂
Welcome 😊
Another good video.
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 🌐 th-cam.com/video/CsH2sB6gwlw/w-d-xo.html
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐th-cam.com/video/xnjCbgu0Qj4/w-d-xo.html
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 th-cam.com/video/2soTybOZkXY/w-d-xo.html
Hi Buddy, Very good videos
Waiting for the ch 21 to 25...
Coming soon
Is it necessary to learn informatica powercenter before learning snowflake?
Not Needed,SQL is prerequisite for learning the SNOWFLAKE
Any data and SQL backgroud is good enough to learn snowflake. Even a non data background can work in snowflake.
Can we grant role access to another role.. instead of using secondary role ALL..
Yes, you can do it... role can be granted to another role as well as anothe user too.
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?
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/)
Good luck for the exam !!
Hi Sushma, what tools you are using for migrating data from Teradata to snowflake?
Hi sir.The videos are amazing.when can i expect next chapter?
Can anyone provide the information.
Will upload soon
Users can also be created with useradmin right?
yes.. right..
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
Thank you much, The notes link isn't working
Great Video as always, Any way I can reach out to you ( over an email or LinkedIn?)
Thanks for these lesson . Could you please share links for chapter 21 to 25 ?
working on it.. will relase soon.. one is coming this weekk
awsome. sir where is link for chapters after 20
Ch-21 is on way.. follow this space.. going to be release this week..
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)
it is owned by the role ( select current_role) and not to the user.
Link for chapter 21 onwards pls
going to be release this week... so watch this space...
Can you pls share the commands