Snowflake architecture consists of mainly three layers. They are the Database storage layer, query processing layer, and Cloud service layer. The Bottom layer is known as the Storage layer or database storage layer, here the data is stored in hybrid columnar format.
The Middle layer is known as the Query processing layer which consists of the virtual warehouse so this layer is called the muscle of the system. The important aspect of the query processing layer is the MPP (Massive Parallel Processing ) and this layer can be scaled up and scaled down automatically. In the snowflake query processing layer we can create any type of virtual warehouse depending on the data load. The virtual warehouse can be auto-resumed and auto-suspended depending upon the freezing time we are set in the virtual warehouse setting.
The Topmost layer in snowflake is known as the Cloud service layer which is called the Brain of the system. In the cloud service layer, authentication and access control, monitoring, optimizer, and handling other crucial data management as well.