Snowflake Architecture

You can get all snowflake Videos, PPTs, Queries, Interview questions and Practice files in my Udemy course for very less price.. I will be updating this content and will be uploading all new videos in this course.
My Snowflake Udemy Course:
www.udemy.com/course/snowflak...
------------------------------------------------------------
Next session on Virtual Warehouses
I can be reachable on [e-mail].

[@ankursingh730]

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

[@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

[@dnyaneshwarshelke7425]

Appreciate your efforst for creating this outstanding videos playlist, There is not such videos of Snowflake in depth on CZcams💥
Thanks again💯

[@mrjana520]

You're very welcome!

[@amaravenkatarao6019]

Thank you for providing videos

[@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🙏

[@reshma1473]

Well explained.Appreciate your efforts

[@shaiksubhani7601]

Assalamu Aleikum

[@prasanthkancharana5206]

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

[@mrjana520]

Yes they are

[@Raghavareddymekala]

please do more videos on snowflake good job sir

[@mrjana520]

All videos are already available in my playlist

[@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

[@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

[@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]

[@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

[@naveensai2175]

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..

[@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

[@naveensai2175]

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

[@hemaammu2337]

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

[@mrjana520]

Yes, correct

[@sasisai8641]

How the three layers communicate when we run a query

[@mrjana520]

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

[@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!

[@skyhigh7424]

This course also covers Snowflake Administration?

[@mrjana520]

Covers 50% of Admin syllabus

[@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]

[@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..

[@user-pz6wr3wy1m]

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]

[@pookiebear205]

Can u please share the ppt ?

[@mrjana520]

Reach me on [e-mail]

[@dharanireddy4462]

Can you please share ppt

[@mrjana520]

Your mail id

[@ssm-fj8ml]

Could you share me the PPT

[@mrjana520]

Mail id?

[@venkatkumar-fo6np]

Could you please share PPT

[@mrjana520]

Mail id

[@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