Reviewed on 26/12/2017
Did a proof of concept for my company comparing Snowflake to other databases that we use.
The three features of many great features that stand out are:
-The REAL separation of compute and storage gives the ultimate flexibility. You can match workloads to the proper level of compute without having one workload collide with another. You can optimize what you spend by only using what you need with the ability to change the size of your compute multiple times a day and the ability to stop and resume compute nodes easily. -No other database I have ever used can handle concurrency like Snowflake. Additional clusters are automatically spun up if a query is queued -There is no tuning that needs to be done as this is a data warehouse as a service. No other database comes close to the Snowflake performance without additional tuning. I can put in some time and tune my Oracle, Teradata or HANA database to get similar or slightly better performance but the level of DBA needed to do this is costly. This is especially helpful when the query patterns to be run against the database are unknown.
Cons: One of the positives above can also be a negative. Snowflake is a service and not software that you can run in your own data center or your own cloud VPC. This CON can be overcome with end to end encryption where you own the key and other Snowflake features.
Reviewed on 12/03/2018
Snowflake is an affordable solution that enables analysts and non-technical folk to build DWs.
Comments: We have a lean team of data engineers and as a result cannot automate as many data sources as we'd like. In the interim, our analysts utilize Snowflake to incorporate data into our multifaceted reports.
Pros: We use Snowflake to capture some of our larger third party data exports that won't fit into Google Sheets. The process of uploading data is straightforward and keeps our business reporting streamlined despite lean engineering resources on our end. There is a SQL interface to make modifications to data before final exports and data viz.
Cons: The UI is clunky and not the most intuitive. The error messages could be more detailed and expanded. The support for Mac seems to be more limited. Encountered issues with data produced via Mac and support took months to fully resolve.
Reviewed on 05/04/2018
Best warehouse in the market
Pros: It's fast. It's simple. It's scalable. And best of all, we saved forty percent from switching off of redshift.
Cons: You can't connect easily from a sql editor outside of their browser or the command line. That makes it less convenient.
Reviewed on 11/07/2019
Doing big things
Comments: Very good.
Pros: A very innovative platform. Very secure. Great interface. Doing great things with Amazon, Google, etc.
Cons: Takes some times to get used to but not a huge deal in the end.
Reviewed on 16/02/2018
Best cloud data warehouse as a service available to date
Comments: Centralized data.
Easy setup and configuration.
The Ability to scale up and scale down at needed.
Pay as you go and only for what you use.
Limited to AWS currently with planned expansion to Azure and GCP.
On-Premise is not an option, but VPC is.
Reviewed on 10/10/2018
Pros: My favorite feature in Snowflake is the ease of use provided by SnowSQL. You can create variables in SQL that you reference throughout your queries. It additionally performs super fast and reduces many management needs.
Cons: Snowflake lacks the ability to create stored procedures, this would add a lot of value and ease of use to the software. While the lack of management is great, I find that it may not always be worth the cost for it. In addition to this, it does not perform well (or at all) as an ETL Tool.
Reviewed on 19/12/2018
Fantastic performance for SQL workloads with huge data sets
Pros: Fantastic performance without worrying about tuning or data set size.
Cons: None! Really fantastic experience for our data teams.
Reviewed on 26/01/2019
Want quick and easy query results? Then yes, Snowflake is correct
Snowflake is a no fluff software that gets you data results FAST. There isn't much you have to worry about or learn to simply start using it.
Since it's cloud based you session is alway saved and you can pick up right where you last started. Love that about it.
Cons: It's very basic, compared to other tools. So if that is what you are looking for then it isn't an issue.
Reviewed on 28/11/2018
Pros: Snowflake db is a cloud based db the most interesting part of this software is that it is cload based and is giving competition to major vandors.
Cons: It's really costlier to buy and one should be specially trained in it