What users are saying about
149 Ratings
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100
149 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100

Likelihood to Recommend

Actian Avalanche

This is a tool geared for smaller to mid-sized business that has disparate sources of data from different platforms in varying incarnations. It’s a great ETL tool to solve the problems a scenario like that causes, but you can also achieve that with good BI Tools like Qlik Sense. So be careful that you really need an ETL tool, as opposed to an end-use tool with a built-in ETL component. If you are going ELT and have a lot of data an not a lot of corporate resources, this is a better option than Microsoft or Informatica
Anonymous | TrustRadius Reviewer

Google BigQuery

One of the most important aspects while working with data warehousing solutions and analytics is the ability to handle large datasets. Google BigQuery is the best in business for that particular aspect. It is ridiculously fast while handling large data sets. Another aspect where it is well suited is the ability to integrate it with data visualization tools like Data Studio. It is fast, easy to use, and very reliable. The only aspect where I feel it is less appropriate where you have to pay more of inefficient scripts and that can hamper the growth of the company a bit.
Rounak Verma | TrustRadius Reviewer

Feature Rating Comparison

Database-as-a-Service

Actian Avalanche
Google BigQuery
9.4
Automatic software patching
Actian Avalanche
Google BigQuery
9.4
Database scalability
Actian Avalanche
Google BigQuery
9.7
Automated backups
Actian Avalanche
Google BigQuery
9.6
Database security provisions
Actian Avalanche
Google BigQuery
9.5
Monitoring and metrics
Actian Avalanche
Google BigQuery
8.4
Automatic host deployment
Actian Avalanche
Google BigQuery
9.5

Pros

Actian Avalanche

  • Quick response for queries involving multi-million rows
  • Low cost
Anonymous | TrustRadius Reviewer

Google BigQuery

  • BigQuery is ridiculously fast and has the ability to query absurdly large data sets to return results immediately.
  • BigQuery allows for storage of a massive amount of data for relatively low prices.
  • Easy to learn. BiqQuery uses SQL-like queries and is easy to transfer your existing skills to use.
Tristan Dobbs | TrustRadius Reviewer

Cons

Actian Avalanche

  • As I said before, more training or greater visibility to training tools/options would be a plus. It’s easy to publish YouTube videos these days, I think they should make more of them.
  • Differentiation would help, there’s not a lot out there to drive you to buy the product if you are well informed in the market. If you know the market, you steer towards the large or trendy products. It’s a good product, but lost in the noise of the field I think.
  • Hitching the wagon to a major software brand (like Mule did to Salesforce) would help grow the user base, and thus increase the activity in the support community. More users also translates into product champions.
Anonymous | TrustRadius Reviewer

Google BigQuery

  • One issue with Google Cloud Storage is its price. For one to have that premium Google Cloud Storage, for the purpose of massive storage, he/she must have adequate cash. Otherwise, Google Cloud Storage is a safe and perfect online storage platform.
  • The only thing that can come to mind that would be annoying with this software was that sometimes when trying to share files on the Cloud with coworkers, it would just not share at all, or there would be a massive delay in when I shared them and when they received them. Other than that though, everything is perfect with this.
Sam Lepak | TrustRadius Reviewer

Usability

Actian Avalanche

No score
No answers yet
No answers on this topic

Google BigQuery

Google BigQuery 9.0
Based on 1 answer
BigQuery is a little bit difficult to learn at first. The tools are all there but it takes a few hours of practice and trial and error to be comfortable processing a large dataset. It can handle quite a bit and the cloud storage makes those experimental practice hours much easier to do in your spare time. The software is capable of doing a lot, it's just a matter of being patient and learning the ways of BigQuery.
Anonymous | TrustRadius Reviewer

Support Rating

Actian Avalanche

No score
No answers yet
No answers on this topic

Google BigQuery

Google BigQuery 8.2
Based on 16 answers
I rated the overall support for Google BigQuery as a mediocre five because it has limited support from Google. Instead, it is heavily dependent on an organization's IT resources such as SQL analysts and Data Architects to run big data reports or maintain data quality. Additionally, if errors occur during a run of complex SQL queries or when sending data to Google BigQuery from other sources, Google provides basic email support which needs to be complemented with internal data warehouse support to fix the root cause of the database errors. Finally, due to constraints on the amount of data an analyst can query or pay the additional cost when exceeding the limit, basic Google support is not sufficient to meet data needs without interruption.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Actian Avalanche

Oracle>DB2>MS SQL Server>GreenPlum>Vectorwise
Anonymous | TrustRadius Reviewer

Google BigQuery

Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
Csaba Toth | TrustRadius Reviewer

Return on Investment

Actian Avalanche

  • We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.
Anonymous | TrustRadius Reviewer

Google BigQuery

  • Google BigQuery has had enormous impact in terms of ROI to our business, as it has allowed us to ease our dependence on our physical servers, which we pay for monthly from another hosting service. We have been able to run multiple enterprise scale data processing applications with almost no investment
  • Since our business is highly client focused, Google Cloud Platform, and BigQuery specifically, has allowed us to get very granular in how our usage should be attributed to different projects, clients, and teams.
  • Plain and simple, I believe the meager investments that we have made in Google BigQuery have paid themselves back hundreds of times over.
Alex Andrews | TrustRadius Reviewer

Screenshots

Pricing Details

Actian Avalanche

General

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

Actian Avalanche Editions & Modules

Additional Pricing Details

Google BigQuery

General

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

Google BigQuery Editions & Modules

Edition
Queries (On-Demand)$51
Queries (Hourly Flex Slots)$42
Queries (Monthly Flat Rate)$20002
Queries (Annual Flat Rate)$1,7002
  1. per TB
  2. per 100 slots
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Actian Avalanche
8.0
Google BigQuery
9.2

Usability

Actian Avalanche
Google BigQuery
9.0

Support Rating

Actian Avalanche
Google BigQuery
8.2

Add comparison