"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"It was relatively easy to use, and it was easy for people to convert to it."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"The technical support is pretty good, particularly if you are a more technical user."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"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 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."
"A very good, open-source platform."
"The parallel load features mean that Greenplum is capable of high-volume data loading in parallel to all of the cluster segments, which is really valuable."
"It's super easy to deploy and it also supports different languages and analytics."
"The solution could use a little bit more UI."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues."
"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."
"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."
"The documentation could improve. They should provide architecture information."
"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."
"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."
"Extra filters would be helpful."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
Snowflake is ranked 1st in Data Warehouse with 49 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 3 reviews. Snowflake is rated 8.4, while VMware Tanzu Greenplum is rated 9.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 VMware Tanzu Greenplum writes "Powerful external data integration and parallel load capabilities, with good technical support". Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica, AWS Lake Formation and Firebolt, whereas VMware Tanzu Greenplum is most compared with Apache Hadoop, Oracle Exadata, Amazon Redshift, Oracle Database Appliance and Teradata. See our Snowflake vs. VMware Tanzu Greenplum report.
See our list of best 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.