We performed a comparison between Actian Ingres 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."The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"I like the idea that you can assign roles and responsibilities, limiting access to data."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
"If you go with one cloud provider, you can't switch."
"Currently, Snowflake doesn't support unstructured data."
"I am still in the learning stage. It has good security, but it can always be more secure."
"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."
"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."
"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."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Actian Ingres is rated 9.0, while Snowflake is rated 8.4. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Actian Ingres is most compared with Oracle Database Appliance, Databricks and Teradata, 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.