Compare Snowflake vs. Vertica

Cancel
You must select at least 2 products to compare!
Snowflake Logo
30,694 views|20,985 comparisons
Vertica Logo
14,490 views|8,334 comparisons
Most Helpful Review
Find out what your peers are saying about Snowflake vs. Vertica and other solutions. Updated: January 2021.
456,495 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.""The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.""They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.""The initial setup is straightforward. You just need to follow the documentation.""The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.""It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.""I like the idea that you can assign roles and responsibilities, limiting access to data.""The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."

More Snowflake Pros »

"Eighty percent of the ETL operations have improved since implementing this solution.""The performance is very good and the aggregate records are fast.""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.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""Speed and resiliency are probably the best parts of this product.""It has improved my organization's functionality and performance.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."

More Vertica Pros »

Cons
"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.""Support needs improvement, as it can take several days before you get some initial support.""The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.""The solution could improve the user interface and add functionality to the system.""Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.""They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in.""If you go with one cloud provider, you can't switch.""Availability is a problem."

More Snowflake Cons »

"Fact-to-fact joins on multi-billion record tables perform poorly.""When it is about to reach the maximum storage capacity, it becomes slow.""Support is an area where it could get better.""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.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""The geospatial functionality could be designed better.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""They could improve on customer service."

More Vertica Cons »

Pricing and Cost Advice
"Pricing can be confusing for customers.""The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year.""You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.""It is not cheap.""The pricing for Snowflake is competitive.""On average, with the number of queries that we run, we pay approximately $200 USD per month.""Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month.""The price of Snowflake is very reasonable."

More Snowflake Pricing and Cost Advice »

"From a cost perspective, the software is less than most of its competitors.""It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."

More Vertica Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
456,495 professionals have used our research since 2012.
Questions from the Community
Top Answer: Apache Hadoop is for data lake use cases. But getting data out of Hadoop for meaningful analytics is indeed need quite an amount of work. by either using spark/Hive/presto and so on. The way i look at… more »
Top Answer: The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.
Top Answer: SQreamDB is a GPU DB. It is not suitable for real-time oltp of course. Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)… more »
Top Answer: The performance is very good and the aggregate records are fast.
Top Answer: When it is about to reach the maximum storage capacity, it becomes slow.
Ranking
1st
Views
30,694
Comparisons
20,985
Reviews
21
Average Words per Review
531
Rating
8.2
4th
Views
14,490
Comparisons
8,334
Reviews
7
Average Words per Review
478
Rating
9.1
Popular Comparisons
Compared 7% of the time.
Compared 7% of the time.
Compared 6% of the time.
Compared 10% of the time.
Compared 9% of the time.
Compared 9% of the time.
Compared 8% of the time.
Compared 6% of the time.
Also Known As
Snowflake ComputingMicro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Learn
Snowflake Computing
Micro Focus
Overview

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.

Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

Offer
Learn more about Snowflake
Learn more about Vertica
Sample Customers
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White OpsCerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Top Industries
REVIEWERS
Computer Software Company33%
Manufacturing Company22%
Media Company11%
Healthcare Company11%
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider15%
Financial Services Firm6%
Media Company5%
REVIEWERS
Computer Software Company23%
Media Company19%
Marketing Services Firm16%
Comms Service Provider13%
VISITORS READING REVIEWS
Computer Software Company36%
Comms Service Provider16%
Financial Services Firm7%
Media Company7%
Company Size
REVIEWERS
Small Business28%
Midsize Enterprise16%
Large Enterprise56%
VISITORS READING REVIEWS
Small Business5%
Midsize Enterprise18%
Large Enterprise77%
REVIEWERS
Small Business30%
Midsize Enterprise25%
Large Enterprise45%
Find out what your peers are saying about Snowflake vs. Vertica and other solutions. Updated: January 2021.
456,495 professionals have used our research since 2012.

Snowflake is ranked 1st in Cloud Data Warehouse with 21 reviews while Vertica is ranked 4th in Cloud Data Warehouse with 7 reviews. Snowflake is rated 8.2, while Vertica is rated 9.0. The top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Snowflake is most compared with Microsoft Azure Synapse Analytics, Firebolt, Amazon Redshift, Teradata and Oracle Autonomous Data Warehouse, whereas Vertica is most compared with Apache Hadoop, Teradata, Amazon Redshift, SQL Server and Oracle Exadata. 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.