Suppose there is a L size vm with 100GB storage, how much percentage is allocated for local disk cache. And will it hamper the performance of other time taking/complex queries execution ?
I don't think we can get the sample data shared by snowflake anymore, there is no download option when I tried. Can you suggest any other way we can get the sample data for practice ? Your videos are awesome .Thank you so much .
Hi Sir.. Your explanation is really awesome. I have one query.. How much space available in the cloud service layer to keep all these meta data management, results cache, etc to handle. I mean from where the cloud service layer gets the space?
data is the actual data stored in database, query results are the data that can be straight forward data, counts, derived columns it can be anything the output of queries we are running.
![[ENGSUB] UNPRODUCTIVE DAY ใช้ชีวิต (เปื่อยๆ) ด้วยกัน 1 วัน! | OUROAD CLOSEFRiEND SS2 EP.9](http://i.ytimg.com/vi/pyYKZ3kra9w/mqdefault.jpg)
your videos are blessings in disguise. Can't thank you enough. its a ultimate pleasure watching and learning from you.
All Sessions were really well explained with examples ..Thank you for your time and sharing content in description
Excellent explanation.Thank you so much.
what a great explanation, Thanks a lot sir
Really very useful and crystal clear explination thank you bro
Excellent explanation. Keep it up
Videos are really awesome
Bro your videos are really awesome
Thank you so much 😀
Is the data stored in micro partitions even in the Result/Local cache ?
yes
Awesome Video!
Suppose there is a L size vm with 100GB storage, how much percentage is allocated for local disk cache.
And will it hamper the performance of other time taking/complex queries execution ?
no, and we are not sure on the percentage
I don't think we can get the sample data shared by snowflake anymore, there is no download option when I tried. Can you suggest any other way we can get the sample data for practice ?
Your videos are awesome .Thank you so much .
There is a video, how to get sample data in my playlist list, try that
Hi Sir.. Your explanation is really awesome.
I have one query.. How much space available in the cloud service layer to keep all these meta data management, results cache, etc to handle. I mean from where the cloud service layer gets the space?
The space is from the cloud where we hosted our snowflake account and it is unlimited
@@mrjana520 thank you for quick response sir.. So this storage and data storage layer both will be differently changed?
There will be no charge for that
what is the difference between results of the querys and data ? can u show the example ? in the
data is the actual data stored in database, query results are the data that can be straight forward data, counts, derived columns it can be anything the output of queries we are running.
Remote Spillover - how can i find last week Remote Spillover queries
I don't understand your question, can you elaborate it