Snowflake, Google BigQuery and Amazon Redshift are the three cloud data warehouses that appear most often in data engineer job descriptions. All three store data in columns, run SQL in parallel, separate storage from compute (at least in their modern versions), read open table formats and offer row and column security. What differs is how you run them : who sizes the compute, how you are billed, which design levers you control, and how tightly each is tied to one cloud.
This page gives you a neutral framework for the comparison. It does not repeat the Snowflake versus Databricks material, which is in Snowflake vs Databricks , or the general warehouse and lakehouse trade-offs in Lake vs warehouse vs lakehouse .
Architecture
Snowflake has three layers: storage, compute and cloud services. Table data is stored once, in compressed columnar micro-partitions, in object storage on whichever cloud hosts the account (AWS, Azure or Google Cloud).…