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.
"The most valuable feature has been the Snowflake data sharing and dynamic data masking."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"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 is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"It is a highly scalable solution. There is no limit on storage or computing."
"It was relatively easy to use, and it was easy for people to convert to it."
"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."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
"I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility."
"These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach."
"It's not that flexible when compared to Oracle."
"Snowflake can improve its machine learning and AI capabilities."
"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."
"The write performance could be improved because it is less than half of the read performance."
"The read/write ratio is an area in the solution with some flaws and needs improvement."
Snowflake is ranked 1st in Data Warehouse with 94 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.