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 product's most important feature is unloading data to S3."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"Data Science capabilities are the most valuable feature."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"Time travel is one feature that really helps us out."
"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."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"The pricing of the solution should be much easier to calculate or find by yourself."
"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 are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
"The product's performance could be improved."
"In future releases, it can also support full unstructured data."
"The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic."
"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."
"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 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 Red Hat Ceph Storage.
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.