We performed a comparison between Snowflake and Vertica based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Vertica has an edge in this comparison due to its excellent performance. Snowflake does come out on top in the Ease of Deployment category, however.
"Data Science capabilities are the most valuable feature."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
"It's ultra-fast at handling queries, which is what we find very convenient."
"The technical support is pretty good, particularly if you are a more technical user."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
"Time travel is one feature that really helps us out."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"Partition and join back to node are easy and simple for DBAs."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Allows us to take volumes and process them at a very high speed."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"Its transaction application needs improvement."
"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."
"The cost of the solution could be reduced."
"There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."
"Sometimes it can be tricky to manage multiple environments if you're purely using Snowflake as your scripting and pipeline environment."
"Pricing is an issue for many customers."
"It needs integration with multiple clouds."
"Suboptimal projection design causes queries to not scale linearly."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"Documentation has become much better, but can always use some improvement."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"They could improve the integration and some of the features in the cloud version."
Snowflake is ranked 1st in Cloud Data Warehouse with 92 reviews while Vertica is ranked 6th in Cloud Data Warehouse with 83 reviews. Snowflake is rated 8.4, while Vertica is rated 8.2. The top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, AWS Lake Formation and Amazon EMR, whereas Vertica is most compared with SQL Server, Amazon Redshift, Teradata, Oracle Exadata and BigQuery. See our Snowflake vs. Vertica report.
See our list of best Cloud Data Warehouse vendors and best 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.