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.
"The initial setup is straightforward. You just need to follow the documentation."
"The solution's computing time is less."
"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
"The solution speeds up the process of onboarding."
"Snowflake's most valuable features are data enrichment and flattening."
"The initial setup is very simple."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"The solution is quick, has good compression data, and is not expensive."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"The extensibility and efficiency provided by their C++ SDK."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"I like the projection feature, which increases query performance."
"The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"Their UiPath, the workspace area, needs some work."
"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."
"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."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
"There are always a few operation updates here and there that can be made."
"The integration with AI has room for improvement."
"The biggest problem is the cost of cloud deployment."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"I have found that coding support could be simplified."
"The integration of this solution with ODI could be improved."
"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."
"The geospatial functionality could be designed better."
"Limitations in group by projections is where I would like to see an improvement."
Snowflake is ranked 1st in Data Warehouse with 94 reviews while Vertica is ranked 4th in 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 Oracle Autonomous Data Warehouse, whereas Vertica is most compared with SQL Server, Amazon Redshift, Teradata, BigQuery and Oracle Exadata. See our Snowflake vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.