Need advice about which tool to choose?Ask the StackShare community!

Google BigQuery

1.7K
1.5K
+ 1
152
Matillion

51
70
+ 1
0
Add tool

Google BigQuery vs Matillion: What are the differences?

Developers describe Google BigQuery as "Analyze terabytes of data in seconds". Run super-fast, SQL-like queries against terabytes of data in seconds, using the processing power of Google's infrastructure Load data with ease. Bulk load your data using Google Cloud Storage or stream it in. Easy access. Access BigQuery by using a browser tool, a command-line tool, or by making calls to the BigQuery REST API with client libraries such as Java, PHP or Python.. On the other hand, Matillion is detailed as "An ETL Tool for BigData". It is a modern, browser-based UI, with powerful, push-down ETL/ELT functionality. With a fast setup, you are up and running in minutes.

Google BigQuery and Matillion can be primarily classified as "Big Data as a Service" tools.

Some of the features offered by Google BigQuery are:

  • All behind the scenes- Your queries can execute asynchronously in the background, and can be polled for status.
  • Import data with ease- Bulk load your data using Google Cloud Storage or stream it in bursts of up to 1,000 rows per second.
  • Affordable big data- The first Terabyte of data processed each month is free.

On the other hand, Matillion provides the following key features:

  • Edit, Transform and Load Data intuitively
  • Load Data from Dozens of Sources
  • 50% reduction in ETL development and maintenance effort
Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Google BigQuery
Pros of Matillion
  • 28
    High Performance
  • 25
    Easy to use
  • 22
    Fully managed service
  • 19
    Cheap Pricing
  • 16
    Process hundreds of GB in seconds
  • 12
    Big Data
  • 11
    Full table scans in seconds, no indexes needed
  • 8
    Always on, no per-hour costs
  • 6
    Good combination with fluentd
  • 4
    Machine learning
  • 1
    Easy to manage
  • 0
    Easy to learn
    Be the first to leave a pro

    Sign up to add or upvote prosMake informed product decisions

    Cons of Google BigQuery
    Cons of Matillion
    • 1
      You can't unit test changes in BQ data
    • 0
      Sdas
      Be the first to leave a con

      Sign up to add or upvote consMake informed product decisions

      What is Google BigQuery?

      Run super-fast, SQL-like queries against terabytes of data in seconds, using the processing power of Google's infrastructure. Load data with ease. Bulk load your data using Google Cloud Storage or stream it in. Easy access. Access BigQuery by using a browser tool, a command-line tool, or by making calls to the BigQuery REST API with client libraries such as Java, PHP or Python.

      What is Matillion?

      It is a modern, browser-based UI, with powerful, push-down ETL/ELT functionality. With a fast setup, you are up and running in minutes.

      Need advice about which tool to choose?Ask the StackShare community!

      Jobs that mention Google BigQuery and Matillion as a desired skillset
      What companies use Google BigQuery?
      What companies use Matillion?
      Manage your open source components, licenses, and vulnerabilities
      Learn More

      Sign up to get full access to all the companiesMake informed product decisions

      What tools integrate with Google BigQuery?
      What tools integrate with Matillion?

      Sign up to get full access to all the tool integrationsMake informed product decisions

      Blog Posts

      Aug 28 2019 at 3:10AM

      Segment

      PythonJavaAmazon S3+16
      7
      2717
      Jul 2 2019 at 9:34PM

      Segment

      Google AnalyticsAmazon S3New Relic+25
      10
      6969
      GitHubPythonNode.js+47
      55
      73089
      What are some alternatives to Google BigQuery and Matillion?
      Google Cloud Bigtable
      Google Cloud Bigtable offers you a fast, fully managed, massively scalable NoSQL database service that's ideal for web, mobile, and Internet of Things applications requiring terabytes to petabytes of data. Unlike comparable market offerings, Cloud Bigtable doesn't require you to sacrifice speed, scale, or cost efficiency when your applications grow. Cloud Bigtable has been battle-tested at Google for more than 10 years—it's the database driving major applications such as Google Analytics and Gmail.
      Amazon Redshift
      It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.
      Hadoop
      The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.
      Snowflake
      Snowflake eliminates the administration and management demands of traditional data warehouses and big data platforms. Snowflake is a true data warehouse as a service running on Amazon Web Services (AWS)—no infrastructure to manage and no knobs to turn.
      Google Analytics
      Google Analytics lets you measure your advertising ROI as well as track your Flash, video, and social networking sites and applications.
      See all alternatives