Snowflake Cloud Data Warehouse

Snowflake is provided as SaaS that runs completely on cloud infrastructure. Storage, Compute and Services layers of Snowflake architecture are deployed and managed on a cloud platform (e.g. AWS and Azure)

Architecture

Snowflake uses a hybrid of traditional shared-disk architectures and shared-nothing database architectures. Snowflake uses a central data repository for persisted data that are accessible from all compute nodes. Queries are processed used MPP compute clusters.

SnowflakeDWArchitecture.PNG

Azure SQL Data Warehouse

Azure Enterprise Enrollment Hierarchy