© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
M. FerleSnowPro™ Core Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9078-1_3

3. Snowflake Architecture

Maja Ferle1  
(1)
Ljubljana, Slovenia
 
Snowflake’s unique architecture consists of three layers:

  • Database storage

  • Query processing

  • Cloud services

The separation into distinct layers allows superior flexibility and cost effectiveness as compared to traditional databases.

This chapter describes each of the architecture layers and their purposes in more detail. Then it walks through and reviews various object types that are stored in Snowflake.

Architecture Layers

Snowflake stores data in a central data repository that ...

Get SnowPro™ Core Certification Companion: Hands-on Preparation and Practice now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial