4 | How Snowflake Clustering helps to Improve Query Performance

In this video, we will discuss how Clustering works in Snowflake tables.
We will cover the following topics:
What is clustering?
How can we operate clustering on tables?
What to consider before or while deciding the clustering?
By the end of the video, you will have a good understanding of how clustering work and how snowflake use them to improve the performance of your Snowflake queries. Gears:
- Microphone - T669-Condenser-Microphone-Adjustable-Scissor - amzn.to/3WB0XCs
- Previous Microphone - Boya ByM1 - amzn.to/3Yc17Bv
- Laptop - Mac book Pro M2 - amzn.to/46zEOIh
(Used in few videos to record in some it is used to edit videos)

[@KNOW-HOW-HUB]

I just want to ask one question on re-clusting .Once cluster keys created will it create new micro partition in the database?

[@HardikPatelN]

Yes it will create new micro partitions as required and old partitions will stay for time travelling.

[@VallabhGhodkeB]

Are tables really by default not clustered ?

[@HardikPatelN]

Yes but naturally ordered by snowflake not based on any given colum or expression