From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Domain 1.0: Part 3 recap

Domain 1.0: Part 3 recap - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Domain 1.0: Part 3 recap

“

So let's just do a recap. And finally, the main one we covered so much ground is one of the biggest domains, but it gives you all the foundational terminology and understanding about the Snowflake architecture and solution that you need for the remaining domain. So it's going to put you in really good stead. Now Snowflake tables are organized into micro partitions. Each one of those micro partitions contains between 50 and 500 MB of uncompressed data, but the actual size and Snowflake will end up smaller because that data is compressed. Storage costs are calculated based upon the daily average of data stored for that bill in month. Snowflake automatically manages the micro partitions, which removes the need for a DBA to look after this. We saw that Snowflake holds metadata about the row stored in each micro partition, including the range of values and number of distinct values and other properties, and that's used for query optimization and efficient query processing as part of the…

Contents