Try our new research platform with insights from 80,000+ expert users

Actian Ingres vs Snowflake comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Actian Ingres
Ranking in Data Warehouse
16th
Average Rating
8.6
Reviews Sentiment
7.9
Number of Reviews
2
Ranking in other categories
Relational Databases Tools (26th)
Snowflake
Ranking in Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
100
Ranking in other categories
Cloud Data Warehouse (1st), AI Synthetic Data (1st)
 

Mindshare comparison

As of July 2025, in the Data Warehouse category, the mindshare of Actian Ingres is 1.1%, up from 0.6% compared to the previous year. The mindshare of Snowflake is 14.0%, down from 19.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

GH
Reliable performance enhances operations with good technical support
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks and the IRS The most valuable features for us are reliability and performance. Our system is used…
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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 valuable features for us are reliability and performance."
"The product's most important feature is unloading data to S3."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"Data Science capabilities are the most valuable feature."
"The querying speed is fast."
"For us, the virtual warehousing is likely the most valuable aspect."
"The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
"It is quite easy to manage."
"The most valuable features of Snowflake are its performance and power."
 

Cons

"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The seamless integration is a bit of an issue."
"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."
"Product activation queries can't be changed while executing."
"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."
"The cost is a bit high."
"The data sharing capabilities across business units within the organization should be better."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"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."
"We would like to see more security including more masking and more encryption at the database level."
 

Pricing and Cost Advice

Information not available
"The price of Snowflake is very reasonable."
"There is a separation of storage and compute, so you only pay for what you use."
"Snowflake is cost-effective."
"It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
"I have not been billed yet, but it should be less. I'm still running the trial version, but it seems to be less than Databricks."
"On average, with the number of queries that we run, we pay approximately $200 USD per month."
"The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year."
"It is hard to say because we're usually engaged in the transition as opposed to the long term. Their storage costs are easily within pennies of what AWS S3 would normally cost. Most of the clients I've been working with are in the financial sector, and they're relatively small. I would put them in an SMB connection. The first thing we have to bring up for people is that they're going to build this. They shouldn't store their data in S3. They should pipeline directly into Snowflake and use it on their storage. So, the cost is a big issue because these are small to medium size companies, and that is the biggest thing we had to price point for them."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
862,514 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
23%
Insurance Company
8%
University
8%
Government
8%
Financial Services Firm
21%
Computer Software Company
13%
Manufacturing Company
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with Actian Ingres?
The seamless integration is a bit of an issue. I would like to see more direct connectors and stuff like SQLAlchemy. It's there but isn't available as a standard, so it involves going to GitHub to ...
What is your primary use case for Actian Ingres?
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks ...
What is your experience regarding pricing and costs for Actian Ingres?
Initially, it's a lot less expensive than competitors. Price performance has always been a priority, ensuring we remain competitive in the market.
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
It is complicated to understand how requests impact warehouse size. Unlike competitors such as Microsoft and Databricks ( /products/databricks-reviews ), Snowflake lacks transparency in estimating ...
What needs improvement with Snowflake?
There is a need for a tool to help me estimate the cost of using Snowflake. Enhancements in user experience for data observability and quality checks would be beneficial, as these tasks currently r...
 

Comparisons

 

Also Known As

Ingres, Ingres 2006
Snowflake Computing
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Actian Ingres vs. Snowflake and other solutions. Updated: July 2025.
862,514 professionals have used our research since 2012.