Snowflake, a prominent cloud data warehouse solution, was revisited in 2024 to re-examine its architecture and internal workings. The platform, known for separating computing and storage, relies on cloud services like Amazon S3, Google Cloud Storage, and Azure Blob Store for storage, and uses a shared-nothing engine for compute power. Snowflake's system includes Virtual Warehouses, columnar storage, vectorized execution, and various caching mechanisms. It also uses FoundationDB for its data catalog management and employs runtime adaptivity in its query optimizer.
Sort: