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.
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
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..
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
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!
Before watching I am giving my comment in this going good and becoming very good
Your explanation is both clear and easy to comprehend. Thank you!
Great explanation!! So easy to understand!!! Thanks
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.
Excellent explanation. Watched multiple other tutorial videos but didn't understood. Finally understood clustering concept here. Thankyou so much
True
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!
Super explination thanks for this video bro do the video on troubleshooting stream
Amazing video. best video i have seen. Thank you.
❤ excellent 👌 session Janardhan sir👍
Explained very nicely ...thanks
Great explanation sir
done a good job Mr sF
Thanks a lot.
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
I understand very well. please upload remaining classes sir.
Except data loading and snowpipe all other concepts available in my channel
Sir in this video are you already insert data into the tables....? (Customer and order table) sir
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
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.
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;
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..
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.
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
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
Sir do you have any project on snowflake
No
Sir please tell me what is the schema... Pls sir
Schema contains tables, views and other database objects and relationships among those tables.
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
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 CZcams videos chala leka udemy course kuda enroll chesukovala
Same videos are there in CZcams 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