We compared Snowflake and VAST Data based on our users reviews in five parameters. After reading the collected data, you can find our conclusion below:
Comparison Results: Snowflake is praised for its easy setup, valuable features, and good customer service. However, it needs improvement in areas like pricing transparency, data integration, user interface, and documentation. On the other hand, VAST Data is commended for its simple and efficient setup, strong failover capability, and good customer service. It could benefit from enhancing its read/write ratio. The pricing perception and user ROI differ for both products.
"Very easy to use and easy to query."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"The product is quite fast."
"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."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"The integration capabilities of the product are good and you get what you pay for when it comes to Snowflake."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"The Mbps they have established is quite a bit faster than any other data warehouse."
"The solution is useful for machine learning and scientific applications, including computer simulations."
"This has been one of the most reliable storage systems that I have ever used."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"The aspect of it that was more complicated was stored procedures. It does not support SQL language-based stored procedures. You have to write in JavaScript. If they supported SQL language and stored procedures, it would make migration from on-prem much simpler. In most cases, if an on-prem solution has stored procedures, they're usually written in SQL. They're not written as what most on-prem DBMS would refer to as an external stored procedure, which is what these feel like to most people because they're written in a language outside of SQL."
"Their UiPath, the workspace area, needs some work."
"Snowflake needs to improve its programming part. Though the tool has Snowpath, it doesn’t support all features like its competitor, Databricks. Snowflake doesn’t support external data ingestion capabilities. You need to have third-party tools for that. Also, the tool needs to incorporate data integration features in its future releases."
"I am still in the learning stage. It has good security, but it can always be more secure."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"Its transaction application needs improvement."
"The solution could improve the user interface and add functionality to the system."
"The read/write ratio is an area in the solution with some flaws and needs improvement."
"The write performance could be improved because it is less than half of the read performance."
Snowflake is ranked 1st in Data Warehouse with 95 reviews while VAST Data is ranked 8th in NVMe All-Flash Storage Arrays with 2 reviews. Snowflake is rated 8.4, while VAST Data is rated 10.0. 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 VAST Data writes "Stability-wise, a device that has been up and running for years". Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation, whereas VAST Data is most compared with Pure Storage FlashBlade, NetApp AFF, Pure Storage FlashArray, Qumulo and DDN Storage Fusion Architecture NVMe.
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.