What is our primary use case?
We use Snowflake for our data warehouse. Amazing product. Redshift cannot compete with a true elastic data warehouse where you can scale computing by just issuing a SQL query (increase computer power) and resizing it down or putting computing unit to sleep.
Snowflake has many more features:
When combined with Alooma, it's the best data integration system. No need for Talend and all these cumbersome tools.
How has it helped my organization?
We were able to implement the entire data eco-system in less than five months, from data integration, data warehousing, ELT, producing fact and dimensional tables, and finally reports.
What is most valuable?
- Computing unit is accessible via SQL: being able to turn them on or off as needed.
- Snowpipe (ingesting data)
- Looking back in time (being able to look at data in the past within a query)
- No data warehouse management
- Support for JSON.
The list is pretty long.
What needs improvement?
- Snowpipe auto-ingest should be automatic.
- A better client UI or command line tool: I think SnowSQL is a little awkward.
For how long have I used the solution?
Less than one year.
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
Which solution did I use previously and why did I switch?
Used it at a previous company.
How was the initial setup?
Yes. No hardware or server config is needed. Just create a user account.
What about the implementation team?
What was our ROI?
What's my experience with pricing, setup cost, and licensing?
Snowflake computing is very affordable. Less expensive than Redshift.
Which other solutions did I evaluate?
Yes. I looked at Redshift and Vertica.