Snowflake Architecture

[@ankursingh730]

It’s very hard to find someone who explains so well!!! Thanks so much for the video.

[@damarlasreemukhi1939]

Thank you so much for the videos. It really helps.

[@mohammedimdaad270]

Though we have 'n' number of paid resources across. Your crispy explanation in Lamen language just osm to understand any concept in a crystal clear way. Great job sir, Thank you very much for the free sessions.

[@SreeDevi-ee1tj]

Excellent || explanation is v gud

[@srikanthbreddy1611]

12:47 micropartitions lo 6 each ga store cheskuntunda ? leka just refrence ki 6 ani cheppara

[@amaravenkatarao6019]

Thank you for providing videos

[@pranaykukadkar7092]

Thank you so much sir your videos are very helpful. I got the offers after learnings from your videos.

[@mrjana520]

that's great to know, congratulations

[@reshma1473]

Well explained.Appreciate your efforts

[@shaiksubhani7601]

Assalamu Aleikum

[@basavaraju1466]

Your videos are helping me very much in understanding Snowflake, Thank you so much. Can you plz do a video on Snowpipe REST API🙏

[@shantanusingh6728]

Thanks for the explanation of the topic. I have a question, Does this playlist cover all the topics for clearing SnowPro Core Certification [ COF-C02 ] ?

[@mrjana520]

Not sure, just check the syllabus of the exam

[@skyhigh7424]

This course also covers Snowflake Administration?

[@mrjana520]

Covers 50% of Admin syllabus

[@Ashu23200]

Which certification is advisable after snowpro core certification? Please guide me.

[@mrjana520]

That depends on your area of interest and your work experience. If you are into data eng filed then go for Snowpro Advanced Data Eng

[@swarajrandhvan9057]

Hello Jana, I have few basic questions, please answer, its a request. 1. Does Snowflake have its own storage? 2. Can we use Snowflake without cloud integration with AWS, Azure, or GCP? 3. Where do we store the data loaded from the internal stage? 4. When we load the data file from an external stage (AWS) into a Snowflake table and delete it from the stage, where will the loaded data be stored?

[@mrjana520]

Hi, answers for all these questions are available in the videos. Go through them and let me know if it is not clear.

[@swarajrandhvan9057]

@@mrjana520 Thank you!

[@prasanthkancharana5206]

What is future of snow flake sir

[@mrjana520]

How can I decide, as of now good, but we should be ready to upgrade ourself at any moment..

[@Raghavareddymekala]

please do more videos on snowflake good job sir

[@mrjana520]

All videos are already available in my playlist

[@naveenyalamala]

Hi Sir ,I heard query results are stored in cloud services layer but you told it was stored in database storage layer(1st point in ppt) so which is correct?

[@mrjana520]

both are true based on situation and the type of query or procedure you are running

[@mechanicalbrand444]

can you give me the examples, i have checked all the sources of snowflake it was stored only in cloud storage layer, not in database storage layer.@@mrjana520

[@harinimmagadda14]

i have a few questions 1)if i am running a query and it got processed within 3 minutes,but my warehouse is still active for one hour.then how i will get charged? 2)to save the credits what we will do when warehose is active? 3)to backup the data we will use cloning,then why will you use time travel if we can do clone?

[@mrjana520]

Reach me on [e-mail]

[@rallabandivijayvijay5456]

Hlo sir can you please share notes or ppt of this videos.really u r teaching an wonderful content.

[@mrjana520]

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for 500 rupees.. I will be updating this content and will be uploading all new videos in this course. And you will have lifelong access to these videos and materials. My Snowflake Udemy Course: www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=4470941B62E9C302EA84 Use the coupon below to get a discount. Coupon: 4470941B62E9C302EA84

[@prasanthkancharana5206]

I am learn power bi and MSBI SQL these are the useful for snow flake

[@mrjana520]

Yes they are

[@hemaammu2337]

Hi sir, so all the three layers are dependent on each other correct me if i am wrong..??

[@mrjana520]

Yes, correct

[@naveenyalamala]

Hi sir ,I have seen Compute cost for virtual warehouse is based on how long then run and the size of the virtual warehouse and the number of clusters if it is a multi cluster warehouse but in your ppt (5th point) compute cost based on query execution time ,can plz clarify this. And one more doubt if i resume a warehouse and not executed any queries however eventually it suspended after 5 minutes without executing any queries. Does this warehouse cost credits?

[@mrjana520]

1. in multi cluster warehouse it depends on both query run time and no.of clusters 2. as per my knowledge yes, that is why we choose auto resume and shorter auto suspend time..

[@ashokrajann9351]

Materialized view is also an object similar to table and it will be stored in the data storage component right? Pls clarify this?

[@mrjana520]

Yes it is the result set stored in data storage

[@NainaNavina-l7h]

Sir in Udemy ,what you provide Coupon code is Inactive...its showing actual price only for Snowflake...can you please provide valid coupon code now

[@mrjana520]

try with this www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=BD5C217109E85F629675

[@saidul.vemireddysfdc4172]

This one also not valid...​@@mrjana520

[@lovelygirl_editz]

Can you share ppt?

[@mrjana520]

Reach me on [e-mail]

[@maheshpimpre8245]

Sir please create one video on snowflake connect with Spring Boot Application with CRUD operation.

[@mrjana520]

I don't have idea on spring boot

[@dharanireddy4462]

Can you please share ppt

[@mrjana520]

Your mail id

[@pookiebear205]

Can u please share the ppt ?

[@mrjana520]

Reach me on [e-mail]

[@ssm-fj8ml]

Could you share me the PPT

[@mrjana520]

Mail id?

[@sasisai8641]

How the three layers communicate when we run a query

[@mrjana520]

Cloud services will take care of the coordination among all 3 layers

[@chanduram4874]

Hi sir please share PPT sir

[@mrjana520]

Your mail id?

[@chanduram4874]

Thankyou for your response sir

[@chanduram4874]

Hi sir I didn't received any email from you sir could please send me sir if you don't mine

[@venkatkumar-fo6np]

Could you please share PPT

[@mrjana520]

Mail id

[@skdonsingh]

I have subscribed your channel. Nice explanation.I want to learn snowflake,I appreciate you if you help me to achieve my goal. Thanks again for your efforts and explained tutorials ❤

[@mrjana520]

Reach me on [e-mail]