Snowflake Tutorial - #13 | Micro Partitions & Data Clustering In Snowflake | Snowflake Hands-on Tutorial

5.0 (1)

10 learners

What you'll learn

This course includes

16.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

Snowflake Micro Partition Snowflake Micro Partition Size Snowflake Static Micro Partition Snowflake Dynamic Micro Partition Snowflake Automatic Micro Partition Snowflake Micro Partition Reclustering Snowflake Cluster Depth Snowflake Cluster Overlap Snowflake Reclusting Cost Snowflake Cluster Ratio Snowflake Micro Partition Vs Bucketing Snowflake Partition

Full Transcript

This tutorial & chapter 13, "Snowflake Micro Partition" covers everything about partition concept applied by snowflake cloud data warehouse to make this cloud data platform super fast and cost effective So enjoy this video series and provide your valuable feedback. Site ➥ https://www.toppertips.com SQL Scripts➥ https://www.toppertips.com/snowflake-micro-partition/ Chapters ----------------------------------------- ➥ 00:00 Micro Partitions Concept in Snowflake ➥ 01:15 Introduction ➥ 02:02 Course Tree Map ➥ 04:31 List, Range, Hash Partition Vs Snowflake Micro Partitions ➥ 06:24 How Snowflake Micro Partition Works? ➥ 07:59 How does micro partition look like? ➥ 10:48 How many micro partitions are created by snowflake? ➥ 13:22 micro partition - clustering depth and clustering overlap ➥ 17:57 micro partition summary and benefit ➥ 19:15 SQL for micro partition & cluster key (create/alter/drop) ➥ 29:18 Micro Partition & Query Profile ➥ 31:42 Micro Partition & Clustering Depth & Cluster Overlap ➥ 35:15 Thank you note 🚀 🚀 Snowflake Tutorials - All Episodes ➥Ch-1-to-25 "Complete Playlist" https://bit.ly/3iNTVGI ➥Ch-1 Snowflake Introduction & History https://bit.ly/3xKHrna ➥Ch-2 Snowflake Free Trial Registration https://bit.ly/3m6uiCL ➥Ch-3 Snowflake Architecture https://bit.ly/3sk2fB2 ➥Ch-4 Snowflake Classic or Legacy WebUI https://bit.ly/3stSyzS ➥Ch-5 Snowflake SnowSight Modern WebUI https://youtu.be/T-l_LN_505Q ➥Ch-6 Snowflake Unique Features https://youtu.be/-MZrCpoAUs0 ➥Ch-7 Snowflake DB/Schema/Table & Data Loading https://youtu.be/Pi3z1NyBd-Y ➥Ch-8 Snowflake Must Know Database Objects https://youtu.be/S5NwU2o2Exg ➥Ch-9 Snowflake Fast Data Loading/Ingestion https://youtu.be/lI5OQPjuj-8 ➥Ch-10 Snowflake Continuous Data Loading https://youtu.be/PNK49SJvXjE ➥Ch-11 Snowflake External Table https://youtu.be/w9BQsOlJc5s ➥Ch-12 Snowflake Virtual Warehouse https://youtu.be/NE07Jx6V4UA ➥Ch-13 Snowflake Micro Partition https://youtu.be/UNBysn1M9Vg ➥Ch-14 Snowflake Time Travel https://youtu.be/9k8ADXunhIk ➥Ch-15 Snowflake Clone Feature https://youtu.be/cAyM-Nj9WOc ➥Ch-16 Snowflake Secure Data Sharing https://youtu.be/2d6d-zZMXtA ➥Ch-17 Snowflake Streams & Change Data Capture https://youtu.be/DXI0GDSwE_E ➥Ch-18 Snowflake Task & Task Tree https://youtu.be/165hXZ_o4Vk ➥Ch-19 ETL (Data Pipeline) in Snowflake https://youtu.be/9FejjGVZrPg ➥Ch-20 Role, Grants & Role Hierarchy in Snowflake https://youtu.be/pZQXK7qO0iY ➥Ch-21 (Part-1) Stored Procedure in Snowflake https://youtu.be/CsH2sB6gwlw ➥Ch-21 (Part-2) User Defined Function in Snowflake https://youtu.be/xnjCbgu0Qj4 ➥Ch-21 (Part-3) Coming Soon, to be published shortly ➥Ch-22 Snowflake Information Schema https://youtu.be/kqZRXoFcKo0 ➥Ch-23 Snowflake Resource Monitor https://youtu.be/2msEUDzp-uU ➥Ch-24 (Part-1) Snowflake JDBC Driver https://youtu.be/tzbqj2y_cbw ➥Ch-24 (Part-2) Snowflake ODBC Driver https://youtu.be/X4uXkGS0dUQ ➥Ch-24 (Part-3) Snowflake Python Connector https://youtu.be/ZrhTYKuGFbo ➥Ch-25 (Part-1) Snowflake & PowerBI Reporting coming-soon ➥Ch-25 (Part-2) Snowflake & Tableau Reporting coming-soon #micropartition #snowflakecomputing #snowflakeclustering #snowflakecompute Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.