Compare Snowflake vs. Vertica
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." | "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." |
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." | "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." |
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." | "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." |
 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: Basically, it is not cheap. | 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  | |
Views 30,694 Comparisons 20,985 Reviews 21 Average Words per Review 531 Rating 8.2 | Views 14,490 Comparisons 8,334 Reviews 7 Average Words per Review 478 Rating 9.1 |
Popular Comparisons | |
 Compared 40% of the time.  Compared 7% of the time.  Compared 7% of the time.  Compared 6% of the time.  Compared 5% 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 Computing | Micro 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 Ops | Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics. |
Top Industries | |
Computer Software Company33% Manufacturing Company22% Media Company11% Healthcare Company11% Computer Software Company33% Comms Service Provider15% Financial Services Firm6% Media Company5% | Computer Software Company23% Media Company19% Marketing Services Firm16% Comms Service Provider13% Computer Software Company36% Comms Service Provider16% Financial Services Firm7% Media Company7% |
Company Size | |
Small Business28% Midsize Enterprise16% Large Enterprise56% Small Business5% Midsize Enterprise18% Large Enterprise77% | 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.