See what Matillion ETL for BigQuery has to offer:

 
Medium
Large
XLarge

EDITION

Edition

Standard
Enterprise
Enterprise

Price

$1.37 per hr
$2.74 per hr
$5.48 per hr

SCOPE LIMITS

Users

Up to 2 per Node
Up to 5 per Node
Up to 12 per Node

Environments

Up to 6 per Node
Up to 15 per Node
Up to 36 per Node

Product Features

Transformation Components

30+ transformation components allow you to perform advanced data transformations in a graphical user interface. These include Filter, Join, Aggregate, Calculator, Rank, Table Input/Output, and many more. For a full list of transformation components, go to https://bigquerysupport.matillion.com/customer/en/portal/topics/801885-transformation-components

Orchestration Components

90+ Orchestration components allow you to orchestrate your ETL processes from start to finish. For a full list of orchestration components, visit https://bigquerysupport.matillion.com/customer/en/portal/topics/816489-orchestration-components

Connectors

50+ native integration components for third party systems (see the integrations page for a full list)

Generic API Connector

The API Query Component in Matillion ETL allows you to integrate with almost any JSON or XML based API. The component converts the API into a pseudo SQL dialect that can then be queried in a similar way to any normal database. This data can then be copied to a table by the component.

Collaboration

Collaboration features include live collaboration, job versioning, integration with DevOps and third-party SCM systems; and multi-environment and multi-schema support for controlling environments.

Dynamic Jobs Using an Advanced Variable System

Pub/Sub Integration

Cloud Pub/Sub component allows messages to be published to a topic on GCP. Other applications can subscribe to these topics to receive said messages. The end result is fast, reliable, secure communication between GCP services and applications.

Scripting in Bash and Python

Run a Bash or Python script

Component Generation Tooling

Project Import/Export

Jobs, environments and variables can be exported from one Matillion ETL instance to be imported to another.

Job Scheduler

Matillion ETL features a scheduler that will launch orchestration jobs automatically at a pre-defined regular time interval. Schedules are set up against a project and you can have multiple schedules set up. The scheduler is straight forward to set and based on Quartz technology.

Versioning

Matillion ETL has versioning features to help you manage versions of your ETL Transformation and Orchestration Jobs. Versioning supports many use cases but perhaps the most typical is to be able to snapshot your development at a point in time to designate as “live” or “production” etc and then continue working on the Default Version.

Multiple Security Options

By default Matillion ETL users are authenticated against an internal user file however it is possible to authenticate users against an Active Directory or other LDAP directory server, turn on and off SSL including certificate management and add and remove users from the local directory using the Administration application.

Search

Through the search tab, users can perform a search (partial match) on any term. This search will span all jobs, notes and component properties within a project and return any matches.

Task Management

Whenever an orchestration or transformation operation is performed by Matillion ETL a Task is created. As an overall Orchestration or Transformation task is performed (such as executing an Orchestration job) the overall Task is broken down into more granular tasks as the execution continues. Task information can be gathered and scrutinised in several ways. Task information is immediately available in the Task panel at the bottom-right of the client interface, giving concise information on recently-run tasks and how they have progressed. These tasks can be viewed in greater detail using the Task Info screen. Meanwhile, a fuller report on all tasks logged by the instance can be found in Task History.

COMPATIBILITY

Support any size/type of BigQuery Data Warehouse

ENTERPRISE FEATURES

Permissions

Almost every service and function in Matillion ETL has been laid out for admins to enable or forbid user access. Micromanage what different users are able to do on the client. Set up read-only users, forbid the deletion of resources or allow scheduling of tasks.

Generated Documentation

One-click generation of documentation for any given job, yielding a downloadable report that details the job layout, components, SQL and properties.

Audit Log

The Audit Log shows a list of significant activity within a Matillion Instance. Most actions by users are logged here in detail such that they are accountable for any changes made.