Snowflake Data Cloud Key Features

What are the key features of the Snowflake Cloud?

25% of the SnowPro Core exam is dedicated to Snowflake AI Data Cloud Features & Architecture. This particular 25% encompasses four areas.

Snowflake's excellent documentation site has a handy article, giving an overview of the key features. This document is not comprehensive, but it's a good starting point.

Here's what you're expected to know for this particular section of Snowflake.

Key Features of the Snowflake Cloud Data Platform

You need to learn all about Snowflake's storage and compute models here, as well as the three layers on which Snowflake is built. You also need to learn about the Data Cloud, the Data Exchange, and the Partner Network. And don't forget about cloud partner categories!

Key Snowflake Tools and User Interfaces

Just what it says really, covering Snowsight, connectors, drivers, SQL scripting and Snowpark. Check this post out for a bit more information.

Snowflake's Catalog and Objects

This is a pretty in-depth subject, but if you've worked with any kind of relational database system you'll be off to a good start. All the usual things are here - schemas, tables, views, UDFs and stored procedures. There are a few things which are a little more specialised, such as tasks, pipes, shares and sequences. The best thing you can do here is have a play - which we'll be doing in future blog posts.

Snowflake Storage Concepts

Last up, do some research on how Snowflake stores data. We've already looked at micro-partitions, but you also need to know about the various types of column metadata clustering Snowflake uses. Two other areas to investigate here are Data Storage Monitoring and Snowflake's Search Optimization Service.

Cover this little lot adequately and you're pretty much a third of the way to passing your exam!

Page top