What users are saying about
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
56 Ratings
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

Snowflake

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
56 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 101

Likelihood to Recommend

Actian Matrix

Actian matrix is not good for small data sets. If you have a limited data pool, or do not plan on having multiple users/clients accessing a data source, stick with a more traditional relational database model - Access for the truly small user base, or a DB2 or Oracle back end if your going to have multiple users, and moderate sized data. Actian is for LARGE data sets (Big Data, in the industry parlance). Millions of rows of data from multiple sources with various down stream systems accessing the database. It is for data analytics of large data groups and intense data mining.
No photo available

Snowflake

Snowflake is great when you need to store large amounts of data while retaining the ability to query that data quickly. It is very reliable and allows for auto-scaling on large queries meaning that you're only paying for the power you actually use. It's taken queries that took 20+ minutes to run on redshift down to 2 minutes on Snowflake.
Jake Schlingman profile photo

Pros

Actian Matrix

  • Super fast. Aggregate query such as SUM(), Count() returns result within seconds from a table with more than billion records.
  • Excellent data compression.
  • Easy maintenance. We managed this database without having a full time DBA.
  • Support ANSI SQL and ODBC/JDBC. It's easy to connect to this database from other systems.
Dipankar Pradhan profile photo

Snowflake

  • Impressive data retrieval and data compression ratio.
  • Semi-structured data (JSON, XML) can be loaded as is and retrieved in a tabular structure on the fly using the flatten function.
  • Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
  • Extensive usages documentation with examples makes development easy.
No photo available

Cons

Actian Matrix

  • Some of the bugs were annoying and QA definitely needs improvement
  • Connectivity to Informatica and ETL providers
  • Workload management could be better like when you compare with Teradata
No photo available

Snowflake

  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
No photo available

Likelihood to Renew

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
No answer on this topic is available.

Snowflake

Snowflake 8.0
Based on 1 answer
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
No photo available

Usability

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
No photo available

Snowflake

Snowflake 8.8
Based on 11 answers
The web front end is OK, but they could improve the product with a front end GUI. We have connected DBEAVER to snowflake with an ODBC driver, but the queries are a lot slower from DBEAVER, compared to the web front end. SSIS also has an ODBC connection, but it is also a slower to pull data from snowflake. Overall the usability is good.
Wicks Justin profile photo

Support

Actian Matrix

Actian Matrix 8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available

Snowflake

Snowflake 7.7
Based on 3 answers
Overall great group of people and they are very insightful. They try to understand what the overall problem is rather than just focusing on the exact issue, which helps put a lot of things into perspective. The turnaround time is very good. I never found myself waiting for more than a couple of days, which is reasonable.
Duncan Hernandez profile photo

Implementation

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available

Snowflake

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix

Actian Matrix is our first big data analytics storage platform, and as I was not involved in the POC process to compare it to other products out on the market, unfortunately I cannot say if it is better than other Big Data storage options. I can say that it out performs products such as Oracle or UDB in regards to the volume of data it can easily index and handle.
No photo available

Snowflake

The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) storage space used and 2) amount of time spent querying data. Snowflake also has a notion of a “logical warehouse” which is the “compute” aspect of the database. These warehouses can be scaled up or down to deliver different grades of performance. You can also configure the number of compute nodes to parallelize query execution. These warehouses can be configured to “pause” when you’re not using them for cost efficiency. As a result, you can have a super beefy warehouse for BI queries that’s only running when people are using your BI tools, while your background batch jobs can use cheaper hardware.
Andrew Goss profile photo

Return on Investment

Actian Matrix

  • ROI is great, less spending on full time DBA and that money could be use to add additional node.
  • Negative - Not many developers are well aware of this tool, it takes some time to learn.
Dipankar Pradhan profile photo

Snowflake

  • Quick installation/setup for a data warehouse solution.
  • Make easy to handle/manage the various type of semi-structured data using the native solutions and provided new data modeling concepts such as schema-read data model and schema-write data model.
  • Make easy and simplified the workload management using virtual warehouses and materialized views.
Jacob Biguvu profile photo

Pricing Details

Actian Matrix

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Snowflake

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison