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.
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"The most valuable feature is the clone copy."
"It's ultra-fast at handling queries, which is what we find very convenient."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"A user-friendly and reliable solution."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
"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."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The solution is quick, has good compression data, and is not expensive."
"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."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"In future releases, it can also support full unstructured data."
"I would like to see a client version of the GUI."
"If you go with one cloud provider, you can't switch."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"Product activation queries can't be changed while executing."
"Snowflake can improve its machine learning and AI capabilities."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"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."
"Support is an area where it could get better."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"The geospatial functionality could be designed better."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"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."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
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.