Overall Satisfaction with Snowflake
Snowflake is used as a scale-out data lake and data warehouse at Spireon. The separation of compute from storage enables the company to provide timely and scalable insights. The confluence of streaming and batch processing at a pay-as-you-go pricing model aids in being intelligent and efficient on budget planning and use.
- Elastic scale
- semi structured storage support
- pay as you go pricing
- getting data to the cloud has been positive
- opex cost has been hard to justify over capex
- analysts are now empowered to interrogate data like never before
- Amazon Redshift, Azure Synapse Analytics (Azure SQL Data Warehouse) and Google BigQuery
Each of the other solutions were cloud vendor specific, Snowflake can ride on either Amazon Web Services, Microsoft Azure, or Google Cloud. The fact that they are ANSI-sql compliant and have an effective means of offloading data makes them portable and easy to sell to teams worried about vendor lock-in.
Do you think Snowflake delivers good value for the price?
Are you happy with Snowflake's feature set?
Did Snowflake live up to sales and marketing promises?
Did implementation of Snowflake go as expected?
Would you buy Snowflake again?
Cloud based analytical data store type workloads where data is volumous and query access patterns are well-known is Snowflake's sweet spot. The MPP engine is second to none and being able to scale up or down on demand enables queries that weren't previously possible. Where Snowflake isn't particularly suited is for on-premise or smaller data workloads or transactional processing workloads.