What users are saying about

Actian Matrix

3 Ratings

Snowflake

16 Ratings

Actian Matrix

3 Ratings
Score 8.6 out of 101

Snowflake

16 Ratings
Score 7.1 out of 101

Add comparison

Likelihood to Recommend

Actian Matrix

[Actian Matrix is well suited for:]1. Power user who wants to derive aggregate metrics by joining huge dataset.2. Batch load where you have to load billion of records very fast (copy command).3. Scenario where you want to do ELT because your ETL tool cannot handle huge volume of data.
Dipankar Pradhan profile photo

Snowflake

Snowflake is great in quick process and ad hoc queries of JSON files (with built-in JSON support). Snowflake would not be the best alternative for sitting on top of Tableau Dashboards - mostly because of the engine being idle and filtering might take additional time. The fact that you only pay for engine time you actually use makes Snowflake is very cost-effective.
No photo available

Pros

  • 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
  • Process Engine control - we can stop/pause/start engines for various tasks.
  • Processing speed is adequate unless there are many users on at the same time.
  • Web interface is easy and intuitive, like the fact that your queries are automatically saved in tabs.
No photo available

Cons

  • Its a new product, there are plenty of bugs to work out with regards to converting special reserve characters that might crop up in data.
  • The Matrix 2 Matrix database port tool needs some ironing out.
No photo available
  • 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 Matrix6.0
Based on 1 answer
No answer on this topic is available.
Snowflake8.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 Matrix6.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
No score
No answers yet
No answers on this topic

Support

Actian Matrix8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available
No score
No answers yet
No answers on this topic

Implementation

Actian Matrix6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available
No score
No answers yet
No answers on this topic

Alternatives Considered

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 is cheaper, but TreasureData has a better interface and much more functionality. Also, TreasureData is able to process a greater number of records more efficiently. TreasureData has the ability to run both Hive and Presto. Also, TreasureData has native APIs for many various products, as well as native SDKs. We are currently using both of them for various things.
No photo available

Return on Investment

  • I cannot comment on the specific numbers, all I can say is that switching to the backend greatly improved our processing speed. The more we process through our systems, the more clients we can serve. Which should bump ROI.
No photo available
  • We are able to organize all the various data sources into one place and run Ad hoc queries against them.
  • Snowflake being very cost effective is definitely saving us $ over their competitors.
  • We are able to track KPIs across various games and compare them to each other, thus knowing where to invest our marketing dollars.
No photo available

Pricing Details

Actian Matrix

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

Snowflake

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