Snowflake is one of the few enterprise ready cloud datawarehouse.

There are 3 layers:-

• Cloud Services-It just stored the meta data information of data.It maintain execution plan .
• Compute-(Query Processing layer)-Query execution is performed in the processing layer. Snowflake processes queries using “virtual warehouses”. Each virtual warehouse is an MPP compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
• Database Storage- When data is loaded into Snowflake, Snowflake reorganizes that data into its internal optimized, compressed, columnar format. Snowflake stores this optimized data in cloud storage.