We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The performance is okay as long as the volume of queries is not too high."
"The Mbps they have established is quite a bit faster than any other data warehouse."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"The technical support on offer is excellent."
"For us, the virtual warehousing is likely the most valuable aspect."
"The pricing is reasonable and matches the rest of the market."
"Can be leveraged with respect to better performance, auto tuning and competition."
"It's ultra-fast at handling queries, which is what we find very convenient."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Pricing is an issue for many customers."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that."
"I am still in the learning stage. It has good security, but it can always be more secure."
"They don't have any SLAs in place. It would be better if they did."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"Snowflake has support for stored procedures, but it is not that powerful."
"They should improve the reporting tools."
"They give a different price for every single company. I don't know if I negotiated that well, but we got the enterprise tier for $3 a credit, and the other two were a dollar-ninety a credit. I suspect we don't have almost zero compute usage, but I know that our annual contract packages are below all of their minimums."
"There is a separation of storage and compute, so you only pay for what you use."
"There is a licensing for this solution and we purchased an enterprise license. Overall the solution is cost-effective."
"Its price should be improved. It should be cheaper than Microsoft."
"I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production."
"The price of Snowflake is very reasonable."
"Snowflake goes by credits. For a financial institution where you have 5,000 employees, monthly costs may run up to maybe $5,000 to $6,000. This is actually based on the usage. It is mostly the compute cost. Your computing cost is the variable that is actually based on your usage. It is pay-per-use. In a pay-per-use case, you won't be spending more than $6,000 to $7,000 a month. It is not more than that for a small or medium enterprise, and it may come down to $100K per year. Storage is very standard, which is $23 a terabyte. It is not much for any enterprise. If you have even 20 terabytes, you are not spending more than $400 per month, which may turn out to be $2,000 to $3,000 per annum."
"You pay based on the data that you are storing in the data warehouse and there are no maintenance costs."
Earn 20 points
IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.
Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.
IBM Db2 Warehouse on Cloud is ranked 11th in Cloud Data Warehouse with 1 review while Snowflake is ranked 1st in Cloud Data Warehouse with 41 reviews. IBM Db2 Warehouse on Cloud is rated 5.0, while Snowflake is rated 8.4. The top reviewer of IBM Db2 Warehouse on Cloud writes "Good performance but poor scalability, and the technical support needs improvement". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". IBM Db2 Warehouse on Cloud is most compared with Amazon Redshift, IBM Netezza Performance Server, Microsoft Azure Synapse Analytics and Oracle Exadata, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica and Firebolt.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.