Why we chose Snowflake as our data warehouse
We recently chose a data warehouse after doing a basic POC of some data warehouses — AWS Redshift, AWS Athena, Snowflake, Google BigQuery. In this slide I share what were some considerations unique to our business due to which we ended up choosing Snowflake and what were the pros and cons of the various warehouses.
This mainly is for sharing the experience that I had while doing POC over the various data warehouses. One thing missing from the slides is BigQuery. I recently got certified as Google Certified Professional — Data Engineer so I already knew its capabilities and hence I did not do a POC over that. Our technology stack was mainly over AWS so going to GCP would have made sense only if there were significant benefits which I did not see while doing the comparison for choosing the data warehouse.
I will do a follow up post to share the good parts of Snowflake in coming weeks. If you have any questions do add to the comments and I will try to answer them as they come.
Edit: I finally got around to writing about Experience with Snowflake.
