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.
@DataEngineering2 жыл бұрын
Great to hear and congratulation... happy to hear that these content help to some extend for your exam preparation.
@srinivassahu52612 жыл бұрын
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
@DataEngineering2 жыл бұрын
Congratulation Srinivas.. thanks for your note..
@kushalthakur0011 Жыл бұрын
Thanks, buddy, As a fresher in the data engineering field your videos helped me a lot. ❣❣❣
@lavesh907 ай бұрын
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🎉
@DataEngineering7 ай бұрын
Glad it was helpful!
@singh_abhishek14292 жыл бұрын
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.
@DataEngineering2 жыл бұрын
Glad you enjoyed it!
@pundrikaxhtripathi2 жыл бұрын
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.
@DataEngineering2 жыл бұрын
Glad it was helpful!
@kirankumar12906 ай бұрын
Excellent Presentation!!! I would like to Thank you very much such Informative session.
@DataEngineering6 ай бұрын
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
@pratik56482 жыл бұрын
Great Explanation
@DataEngineering2 жыл бұрын
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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@annahopp2 ай бұрын
Very useful.
@tableaututorialstips713 ай бұрын
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
@jk176 ай бұрын
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.
@DataEngineering6 ай бұрын
For that you have to use future concepts...
@jk176 ай бұрын
@@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?
@rajeshg38102 жыл бұрын
Excellent session ,thanks
@DataEngineering2 жыл бұрын
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.81139 ай бұрын
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.
@srujanchinnu64302 жыл бұрын
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
@DataEngineering2 жыл бұрын
working on it.. will be published soon
@shailendravernekar23892 жыл бұрын
Thank you so much ...... very informative video
@DataEngineering2 жыл бұрын
So nice of you
@divymistry8737 Жыл бұрын
Thanks 🙂
@DataEngineering Жыл бұрын
Welcome 😊
@willywooca5 ай бұрын
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?
@DataEngineering5 ай бұрын
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.
@willywooca5 ай бұрын
@@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?
@anilkumarm294323 күн бұрын
Thank you much, The notes link isn't working
@saranshchoudhary3992 жыл бұрын
Hi Buddy, Very good videos Waiting for the ch 21 to 25...
@DataEngineering2 жыл бұрын
Coming soon
@thamilkadavarayar67072 жыл бұрын
Another good video.
@DataEngineering2 жыл бұрын
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..
@TechCoach2 ай бұрын
Great Video as always, Any way I can reach out to you ( over an email or LinkedIn?)
@chaitanyakrishna58732 жыл бұрын
Can we grant role access to another role.. instead of using secondary role ALL..
@DataEngineering2 жыл бұрын
Yes, you can do it... role can be granted to another role as well as anothe user too.
@saisindhugurram98345 ай бұрын
Users can also be created with useradmin right?
@DataEngineering5 ай бұрын
yes.. right..
@raghum68082 жыл бұрын
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..
@DataEngineering2 жыл бұрын
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.
@raghum68082 жыл бұрын
@@DataEngineering Thanks for the clarification..
@raghum68082 жыл бұрын
IF possible could you please do video on ORGADMIN role.. Please
@DataEngineering2 жыл бұрын
@@raghum6808 Sure, will do as separete video and not part of this playlist. Thanks for your note.
@DataEngineering2 жыл бұрын
@@raghum6808 Welcome
@radhikamalpani29272 жыл бұрын
Is it necessary to learn informatica powercenter before learning snowflake?
@joshipodili62102 жыл бұрын
Not Needed,SQL is prerequisite for learning the SNOWFLAKE
@DataEngineering2 жыл бұрын
Any data and SQL backgroud is good enough to learn snowflake. Even a non data background can work in snowflake.
@srinivassahu52612 жыл бұрын
Thanks for these lesson . Could you please share links for chapter 21 to 25 ?
@DataEngineering2 жыл бұрын
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.
@kusumamathi98122 жыл бұрын
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)
@DataEngineering2 жыл бұрын
it is owned by the role ( select current_role) and not to the user.
@sushmamanagundi3662 жыл бұрын
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?
@DataEngineering2 жыл бұрын
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_abhishek14292 жыл бұрын
Good luck for the exam !!
@Buzzingfact2 жыл бұрын
Hi Sushma, what tools you are using for migrating data from Teradata to snowflake?
@mahak392 жыл бұрын
Hi sir.The videos are amazing.when can i expect next chapter?
@mahak392 жыл бұрын
Can anyone provide the information.
@DataEngineering2 жыл бұрын
Will upload soon
@ashishpatil90232 жыл бұрын
awsome. sir where is link for chapters after 20
@DataEngineering2 жыл бұрын
Ch-21 is on way.. follow this space.. going to be release this week..
@LaxmanKumar-zf4sc11 ай бұрын
Can you pls share the commands
@ashishpatil61742 жыл бұрын
Link for chapter 21 onwards pls
@DataEngineering2 жыл бұрын
going to be release this week... so watch this space...