Snowflake - Micro-Partitions and Data Clustering

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии •

  • @dikshamittal8310
    @dikshamittal8310 2 года назад +4

    This is the best explanation on Micropartition and clustering. Thank you Janardhan!

  • @yaswanthgenji3922
    @yaswanthgenji3922 Год назад +1

    Your explanation is both clear and easy to comprehend. Thank you!

  • @shilpagowda4231
    @shilpagowda4231 Год назад +2

    Excellent explanation. Watched multiple other tutorial videos but didn't understood. Finally understood clustering concept here. Thankyou so much

  • @Supravallika
    @Supravallika 3 месяца назад

    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.

  • @ankursingh730
    @ankursingh730 Год назад +2

    Great explanation!! So easy to understand!!! Thanks

  • @kishoreevani5813
    @kishoreevani5813 2 года назад +2

    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.

  • @bharathkandati3911
    @bharathkandati3911 Год назад +2

    Thank you Janardhan, Very Helpful!

  • @rithishkonduri508
    @rithishkonduri508 3 месяца назад +1

    Nice explanation. On point.

  • @shaikjakeer1347
    @shaikjakeer1347 2 года назад +2

    Before watching I am giving my comment in this going good and becoming very good

  • @mohammedvahid5099
    @mohammedvahid5099 Год назад +2

    ❤ excellent 👌 session Janardhan sir👍

  • @ashu60071
    @ashu60071 Год назад +1

    Amazing video. best video i have seen. Thank you.

  • @msenthilkumar1124
    @msenthilkumar1124 Год назад +1

    done a good job Mr sF

  • @rohithkumarreddybhavanam8001
    @rohithkumarreddybhavanam8001 11 месяцев назад +1

    Great explanation sir

  • @yamunau.yamuna5189
    @yamunau.yamuna5189 Год назад +1

    Super explination thanks for this video bro do the video on troubleshooting stream

  • @prasannak2940
    @prasannak2940 Год назад +1

    Explained very nicely ...thanks

  • @muktiarahamed890
    @muktiarahamed890 Год назад +2

    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

    • @mrjana520
      @mrjana520  Год назад +5

      I don't have that equipment to bring data from multiple databases

    • @bandlarohithrayal8221
      @bandlarohithrayal8221 Год назад

      ​@@mrjana520 please do the mini project on snowflake

  • @DHswathi
    @DHswathi Год назад

    Sir in this video are you already insert data into the tables....? (Customer and order table) sir

  • @RK-wf7re
    @RK-wf7re 2 года назад +1

    Your explanation is awesome. One question, how snowflake can understand name ' Y' is available in 3 & 4 partitions only?

    • @mrjana520
      @mrjana520  2 года назад +1

      Because of the metadata maintained by Snowflake, here metadata means distinct values for each column of the table.

  • @swapnaramvallepu
    @swapnaramvallepu 9 месяцев назад +1

    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.

  • @VinayKumar-rx1hp
    @VinayKumar-rx1hp 5 месяцев назад

    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?

    • @mrjana520
      @mrjana520  5 месяцев назад

      It is not fixed

  • @ankitrahude6408
    @ankitrahude6408 Год назад

    Hi jana, thank you for detail explanation.
    Question - Can we remove the clustering key of a table ? if yes then how ?

    • @mrjana520
      @mrjana520  Год назад +1

      yes, we can drop cluster keys by using below query.
      ALTER TABLE table_name DROP CLUSTERING KEY;

  • @swarnachittyttt4077
    @swarnachittyttt4077 Год назад

    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.

    • @mrjana520
      @mrjana520  Год назад

      Answer is there in that video itself, please watch it completely

    • @karimam5959
      @karimam5959 Год назад

      4

  • @vijaysurya6696
    @vijaysurya6696 Год назад

    Am unable to get performance optimization with help of clustering. With or without cluster I am getting same amount of Partitions getting scanned

    • @mrjana520
      @mrjana520  Год назад +1

      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

    • @vijaysurya6696
      @vijaysurya6696 Год назад +1

      @@mrjana520 oops extremely sorry friend's. By mistake i was querying a wrong table for comparison. Actually it's giving better results.

  • @rakeshkumarrout4236
    @rakeshkumarrout4236 4 месяца назад

    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.

    • @mrjana520
      @mrjana520  4 месяца назад

      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

  • @DHswathi
    @DHswathi Год назад

    select*from PUBLIC. CUSTOMER_NONCLUSTER where c_nationkey=2; ...........sir here what is the meaning of two little bit confusion pls rply me sir

    • @mrjana520
      @mrjana520  Год назад +1

      There 2 is a nation key, you can get that corresponding nation name from nations table where nation id is 2

  • @divityvali8454
    @divityvali8454 4 месяца назад

    Sir do you have any project on snowflake

  • @venkatakrishna9333
    @venkatakrishna9333 2 года назад

    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

    • @mrjana520
      @mrjana520  2 года назад +1

      share your screen, i will show you how to get it, I can be reachable on jana.snowflake2@gmail.com

    • @venkatakrishna9333
      @venkatakrishna9333 2 года назад

      @@mrjana520 okay sir

    • @bandhuarun9220
      @bandhuarun9220 Месяц назад

      Sir same issue need your help

  • @kpfgf2361
    @kpfgf2361 Год назад

    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?

    • @mrjana520
      @mrjana520  Год назад

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

    • @kpfgf2361
      @kpfgf2361 Год назад

      Many thanks again for your quick response. Iam learning snowflake from your videos only.great Job for creating such videos..

  • @karimam5959
    @karimam5959 Год назад

    Thanks a lot.

  • @competativeworld4677
    @competativeworld4677 2 года назад +1

    I understand very well. please upload remaining classes sir.

    • @mrjana520
      @mrjana520  2 года назад

      Except data loading and snowpipe all other concepts available in my channel

  • @DHswathi
    @DHswathi Год назад

    Sir please tell me what is the schema... Pls sir

    • @mrjana520
      @mrjana520  Год назад

      Schema contains tables, views and other database objects and relationships among those tables.

  • @trajini892
    @trajini892 Год назад

    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.

    • @mrjana520
      @mrjana520  Год назад

      Now the database is named as SNOWFLAKE_SAMPLE_DATA, so use like that

  • @9441982827
    @9441982827 Год назад

    Hi Janardhan, snowflake nerchukovadaniki Mee RUclips videos chala leka udemy course kuda enroll chesukovala

    • @mrjana520
      @mrjana520  Год назад +2

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

    • @9441982827
      @9441982827 Год назад

      @@mrjana520 thanks for the quick response.your videos are very much helpful