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 most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
"Very easy to use and easy to query."
"The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Its projections and encoding are excellent tools for tuning large volumes."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"Allows us to take volumes and process them at a very high speed."
"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."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"The pricing of the solution should be much easier to calculate or find by yourself."
"The design of the product is easily misunderstood."
"Availability is a problem."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"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."
"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."
"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."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"The integration with AI has room for improvement."
"The biggest problem is the cost of cloud deployment."
"It needs integration with multiple clouds."
"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."
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.