We changed our name from IT Central Station: Here's why
Cancel
You must select at least 2 products to compare!
Snowflake Logo
37,053 views|27,399 comparisons
Vertica Logo
9,414 views|6,807 comparisons
Featured Review
Find out what your peers are saying about Snowflake vs. Vertica and other solutions. Updated: January 2022.
564,322 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
"The initial setup is very simple.""The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently.""Great scalability and near zero maintenance.""The Mbps they have established is quite a bit faster than any other data warehouse.""Can be leveraged with respect to better performance, auto tuning and competition.""All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse.""It's ultra-fast at handling queries, which is what we find very convenient.""I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."

More Snowflake Pros →

"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.""Speed and resiliency are probably the best parts of this product.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""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.""Allows us to take volumes and process them at a very high speed.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.""It has improved my organization's functionality and performance."

More Vertica Pros →

Cons
"Snowflake has support for stored procedures, but it is not that powerful.""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.""In future releases, it can also support full unstructured data.""Their UiPath, the workspace area, needs some work.""Every product has room for improvement, although in this case, it needs some broadening of the functionality.""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.""The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it.""The documentation could improve. They should provide architecture information."

More Snowflake Cons →

"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them.""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.""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.""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.""When it is about to reach the maximum storage capacity, it becomes slow.""The geospatial functionality could be designed better.""They could improve the integration and some of the features in the cloud version."

More Vertica Cons →

Pricing and Cost Advice
  • "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."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • 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."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    564,322 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert.
    Top Answer: 
    For our licensing, we renew every January by $25,000 in both credits. Their pricing structure is a pay-per-second usage in terms of credits, but you can get discounts if you buy them in bulk. I think… more »
    Top Answer: 
    The documentation could improve. They should provide architecture information. There could be better integration with tools other than the common databases used to receive data. There are other tools… more »
    Top Answer: 
    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… more »
    Top Answer: 
    The pricing could improve, it is a little expensive.
    Top Answer: 
    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. I know that's… more »
    Ranking
    1st
    Views
    37,053
    Comparisons
    27,399
    Reviews
    40
    Average Words per Review
    578
    Rating
    8.4
    5th
    Views
    9,414
    Comparisons
    6,807
    Reviews
    7
    Average Words per Review
    501
    Rating
    9.4
    Comparisons
    Also Known As
    Snowflake Computing
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    Learn More
    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
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm11%
    Comms Service Provider7%
    Manufacturing Company7%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider15%
    Financial Services Firm8%
    Insurance Company5%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company32%
    Comms Service Provider21%
    Financial Services Firm7%
    Media Company4%
    Company Size
    REVIEWERS
    Small Business25%
    Midsize Enterprise27%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise15%
    Large Enterprise68%
    REVIEWERS
    Small Business31%
    Midsize Enterprise26%
    Large Enterprise44%
    Find out what your peers are saying about Snowflake vs. Vertica and other solutions. Updated: January 2022.
    564,322 professionals have used our research since 2012.

    Snowflake is ranked 1st in Cloud Data Warehouse with 41 reviews while Vertica is ranked 5th in Cloud Data Warehouse with 11 reviews. Snowflake is rated 8.4, while Vertica is rated 9.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 "Superior performance in speed and resilience makes this a very good warehousing solution". Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Teradata, Oracle Exadata and AWS Lake Formation, whereas Vertica is most compared with Amazon Redshift, Teradata, SQL Server, Oracle Exadata and Microsoft Azure Synapse Analytics. 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.