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 efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"It is quite easy to manage."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"The product's most important feature is unloading data to S3."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"The most valuable features of Snowflake are its performance and power."
"The product is quite fast."
"Can be leveraged with respect to better performance, auto tuning and competition."
"This has been one of the most reliable storage systems that I have ever used."
"The solution is useful for machine learning and scientific applications, including computer simulations."
"I would like to see a client version of the GUI."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"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."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Snowflake needs transparency over costs and pricing."
"Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market."
"If you go with one cloud provider, you can't switch."
"Snowflake has support for stored procedures, but it is not that powerful."
"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 92 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 MinIO.
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.