We performed a comparison between Aster Data Map Reduce and Snowflake based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."It's stable and reliable."
"The most valuable feature is the ease of uploading data from multiple sources."
"The ease of deployment is useful so clients are up and running quickly in comparison to other products."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
"The speed of data loading and being able to quickly create the environment are most valuable."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."
"The adaptation to development languages is most valuable. Our developers can SQL code or something else. It has been convenient in that regard."
"There are some ways that the handling of unstructured data could be improved."
"It is hard for some of our users to set up rules for cleansing and transforming data, so this is something that could be improved."
"From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing."
"There are always a few operation updates here and there that can be made."
"Their UiPath, the workspace area, needs some work."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"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."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"More data governance and access control features would be a welcome addition."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"The documentation could improve. They should provide architecture information."
Aster Data Map Reduce is ranked 19th in Data Warehouse with 3 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Aster Data Map Reduce is rated 7.4, while Snowflake is rated 8.4. The top reviewer of Aster Data Map Reduce writes "Has good base product functionality of data storage and analytics but there should be an option to use it on the cloud ". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Aster Data Map Reduce is most compared with , whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation.
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.