* 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… more»
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 needs improvement?
* Snowpipe auto-ingest should be automatic. * A better client UI or command line tool: I think SnowSQL is a little awkward.
What's my experience with pricing, setup cost, and licensing?
Snowflake computing is very affordable. Less expensive than Redshift.
Which solution did I use previously and why did I switch?
I really like the auto-tuning, auto-scaling, automatic load balancing, and query tuning in the system.
What other advice do I have?
I would like to see an on-premise solution in the future. There are other very good solutions in the market, so if I would rate it a ten, it would be the best in the market. I, therefore, rate this solution an eight out of ten.
Which other solutions did I evaluate?
Other options out there are Microsoft Azure Data Warehouse and AWS Redshift. Anyone who has to deal with analytics, to get the processes, marketing processes, and financial processes working, should consider a data warehouse solution because a data warehouse solution is always the underlying infrastructure for good analytics.