Data Engineering, Data Analytics, Database, Snowflake, Software Engineering.
As mentioned above, Snowflake compute follows a shared-nothing architecture, but the local disk only stores cache and temporary data. The cache is the collection of table files from S3, which is last used by the node; it holds the file header and needed columns from the query. The cache only lives