Your way of explaining with examples is excellent, Sir. It really helps us gain clarity on the subject.But it is tricky to analyse columary and table level how it will consume less time to run.
This topic is a bit tricky but your explanation is simply awesome.. great job sir.. keep doing more videos in snowflake. If possible please do video on roles for developers and dba in snowflake.
Excellent explanation. Request you to make video on snowflake dwh end to end project . Bringing data from different sources into stages then to applying transformations And loading into respective dimensional and fact table
Hello sir the explanation is too good and am stuck at when i was doing practice that time i was unable to see below database private sharing in my trail account can you please help me here.
That depends on 3 things, 1. Query you are running 2. Columns you have created cluster keys on 3. The size of the table and distinct values stored on those cluster column
Sir I am now reading snowflake through your video. But the way yo said that extract query get query this function will not work now. so what can i do sir. For practice i want this query. Please sir comment.
Hi, if you are speaking about getting the shared data for your practice, sometimes the data is directly available in SNOWFLAKE_SAMPLE_DATA database, if not please check the updated way from below Snowflake documentation site. docs.snowflake.com/en/user-guide/sample-data-using
Thanks alot for your videos.Are the clusters same as index in oracle, Please answer sir.. if yes, can we create index as well along with the clusters on any tables. How the performance?
No indexes and cluster keys are not same. And there is no Indexes concepts in Snowflake, don't bother about performance, it will be good, if your table is too big and accessing the table frequently then create cluster keys on that table..
INSERT INTO PUBLIC.CUSTOMER_NONCLUSTER SELECT * FROM SAMPLE_DATA.TPCH_SF1000.CUSTOMER; SIR TO CREATE A TABLE IT WILL LOOK LIKE THIS . Database 'SAMPLE_DATA' does not exist or not authorized.
This is the best explanation on Micropartition and clustering. Thank you Janardhan!
Your explanation is both clear and easy to comprehend. Thank you!
Excellent explanation. Watched multiple other tutorial videos but didn't understood. Finally understood clustering concept here. Thankyou so much
True
Your way of explaining with examples is excellent, Sir. It really helps us gain clarity on the subject.But it is tricky to analyse columary and table level how it will consume less time to run.
Great explanation!! So easy to understand!!! Thanks
This topic is a bit tricky but your explanation is simply awesome.. great job sir.. keep doing more videos in snowflake. If possible please do video on roles for developers and dba in snowflake.
Thank you Janardhan, Very Helpful!
Nice explanation. On point.
Before watching I am giving my comment in this going good and becoming very good
❤ excellent 👌 session Janardhan sir👍
Amazing video. best video i have seen. Thank you.
done a good job Mr sF
Great explanation sir
Super explination thanks for this video bro do the video on troubleshooting stream
Explained very nicely ...thanks
Excellent explanation. Request you to make video on snowflake dwh end to end project . Bringing data from different sources into stages then to applying transformations And loading into respective dimensional and fact table
I don't have that equipment to bring data from multiple databases
@@mrjana520 please do the mini project on snowflake
Sir in this video are you already insert data into the tables....? (Customer and order table) sir
Your explanation is awesome. One question, how snowflake can understand name ' Y' is available in 3 & 4 partitions only?
Because of the metadata maintained by Snowflake, here metadata means distinct values for each column of the table.
Hello sir the explanation is too good and am stuck at when i was doing practice that time i was unable to see below database private sharing in my trail account can you please help me here.
Does micropartition is fixed that it can only allow 6 rows per one micropartition? How it is taking only 6 rows of data for one micropartition?
It is not fixed
Hi jana, thank you for detail explanation.
Question - Can we remove the clustering key of a table ? if yes then how ?
yes, we can drop cluster keys by using below query.
ALTER TABLE table_name DROP CLUSTERING KEY;
Hi, i have a doubt.how many cluster keys we can create on a single table?
Is it possible to create two cluster keys on a single table.
Answer is there in that video itself, please watch it completely
4
Am unable to get performance optimization with help of clustering. With or without cluster I am getting same amount of Partitions getting scanned
That depends on 3 things, 1. Query you are running 2. Columns you have created cluster keys on 3. The size of the table and distinct values stored on those cluster column
@@mrjana520 oops extremely sorry friend's. By mistake i was querying a wrong table for comparison. Actually it's giving better results.
Sir I am now reading snowflake through your video. But the way yo said that extract query get query this function will not work now. so what can i do sir. For practice i want this query. Please sir comment.
Hi, if you are speaking about getting the shared data for your practice, sometimes the data is directly available in SNOWFLAKE_SAMPLE_DATA database, if not please check the updated way from below Snowflake documentation site.
docs.snowflake.com/en/user-guide/sample-data-using
select*from PUBLIC. CUSTOMER_NONCLUSTER where c_nationkey=2; ...........sir here what is the meaning of two little bit confusion pls rply me sir
There 2 is a nation key, you can get that corresponding nation name from nations table where nation id is 2
Sir do you have any project on snowflake
No
i can create new snowflake account i cant see get the data option in data in private sharing then how to download and how to get the data
share your screen, i will show you how to get it, I can be reachable on jana.snowflake2@gmail.com
@@mrjana520 okay sir
Sir same issue need your help
Thanks alot for your videos.Are the clusters same as index in oracle, Please answer sir.. if yes, can we create index as well along with the clusters on any tables. How the performance?
No indexes and cluster keys are not same. And there is no Indexes concepts in Snowflake, don't bother about performance, it will be good, if your table is too big and accessing the table frequently then create cluster keys on that table..
Many thanks again for your quick response. Iam learning snowflake from your videos only.great Job for creating such videos..
Thanks a lot.
I understand very well. please upload remaining classes sir.
Except data loading and snowpipe all other concepts available in my channel
Sir please tell me what is the schema... Pls sir
Schema contains tables, views and other database objects and relationships among those tables.
INSERT INTO PUBLIC.CUSTOMER_NONCLUSTER
SELECT * FROM SAMPLE_DATA.TPCH_SF1000.CUSTOMER; SIR TO CREATE A TABLE IT WILL LOOK LIKE THIS . Database 'SAMPLE_DATA' does not exist or not authorized.
Now the database is named as SNOWFLAKE_SAMPLE_DATA, so use like that
Hi Janardhan, snowflake nerchukovadaniki Mee RUclips videos chala leka udemy course kuda enroll chesukovala
Same videos are there in RUclips and udemy, if you want all ppts, queries, practice files along with videos go for Udemy at 599 rupees..
@@mrjana520 thanks for the quick response.your videos are very much helpful