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

Snowflake

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

Likelihood to Recommend

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

Snowflake

For an organization that has small, medium, or large data collection, Snowflake provides the best infrastructure to store, manage, utilize and analyze the data. Especially for companies that are growing at a really fast pace, it helps you not only with warehouse capabilities but also its connection with several BI tools give you the flexibility and option to connect and analyze the data [in] real time.
Rounak Verma | TrustRadius Reviewer

Pros

Actian Matrix (discontinued)

  • 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 | TrustRadius Reviewer

Snowflake

  • This is a cloud-based application that provides me a secure platform for the easy sharing of data with my clients.
  • I feel confident to connect with my numerous business partners just because of its advanced security and effective programming.
  • Through this tool, I am capable of integrating, analyzing, and the entire data in a precise form and with analytics as well, due to which I always have a transparent idea about the data extraction and its transfer from multiple clouds.
Darren Mihalic | TrustRadius Reviewer

Cons

Actian Matrix (discontinued)

  • 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
Anonymous | TrustRadius Reviewer

Snowflake

  • Snowflake UI can be clunky and breaks sometimes, which can be annoying
  • Snowflake has to be paired with the Data Build Tool (DBT) to allow for templating and macro usage. No inbuilt solution.
  • Snowflake Python connector development doesn't necessarily track popular packages such as Pandas as quickly as Pandas releases
  • Could do with better machine learning capability over warehouse tables, but I assume this is coming soon
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Actian Matrix (discontinued)

Actian Matrix (discontinued) 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
Anonymous | TrustRadius Reviewer

Usability

Actian Matrix (discontinued)

Actian Matrix (discontinued) 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
Anonymous | TrustRadius Reviewer

Snowflake

Snowflake 8.7
Based on 11 answers
The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Jake Schlingman | TrustRadius Reviewer

Support Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 8.0
Based on 2 answers
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
Anonymous | TrustRadius Reviewer

Snowflake

Snowflake 8.9
Based on 10 answers
Overall, the support from Snowflake has been very good. Since we are one of the major users for Snowflake and have a dedicated tech team to solve all the technical problem on our way. On the side of the technical problem, any sql related questions can be found from everywhere online.
Anonymous | TrustRadius Reviewer

Implementation Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 6.0
Based on 2 answers
Leader failover setup is the toughest and lack of proper documentation is making things tough.
Anonymous | TrustRadius Reviewer

Snowflake

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

Snowflake

In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best among them for most customers. It's easier to manage, in many cases faster, and in almost all cases it is less expensive because of the ability to automatically resume and suspend depending on usage.
Brian Bickell | TrustRadius Reviewer

Return on Investment

Actian Matrix (discontinued)

  • 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 | TrustRadius Reviewer

Snowflake

  • Faster data retrieval makes real time analysis possible.
  • Option to create multiple warehouses enable us to track usages and cost by departments.
  • Option to scale up/down computational warehouse to support peak hours and month end loads makes Snowflake cost effective.
  • Zero-copy cloning reduces storage and deployment cost.
  • Multiple users can access the same amount of data without deadlocks which is a common scenario in relational databases.
Anonymous | TrustRadius Reviewer

Pricing Details

Actian Matrix (discontinued)

General

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

Actian Matrix (discontinued) Editions & Modules

Additional Pricing Details

Snowflake

General

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

Snowflake Editions & Modules

Edition
US East$20.001
  1. Per TB
Additional Pricing Details

Add comparison