Snowflake SnowPro™ Advanced Architect Certification Companion: Hands-on Preparation and Practice

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

R. SoniSnowflake SnowPro™ Advanced Architect Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9262-4_7

7. Clustering and Micro-Partitions

Ruchi Soni¹  

(1)

New Delhi, India

 

Traditional databases use static partitioning where users partition tables based on an attribute. In this case, the number of partitions is fixed, but the size may not be the same. This requires users to include a partition clause in a CREATE TABLE statement to create a partitioned table. This form of partition has limitations such as maintenance overhead, internal fragmentation, etc.

Snowflake, on the other hand, has a unique way of partitioning ...