What is Snowflake Architecture ? | Most asked Interview Q&A

#snowflake #interviewquestions #interviews

Explain Snowflake Architecture
The Snowflake architecture is composed of three main layers: storage layer, compute layer / query processing layer, and cloud services layer.
And it is a hybrid of shared- and shared-nothing database architecture in order to combine the both. Snowflake utilizes a central data repository for constant data, which is available to all compute nodes similar to shared-disk architecture. But, equal as with shared-nothing architectures. Snowflake uses massively parallel processing (MPP) clusters for query processing. (in which each node stores part of the whole data set locally.)