See what Matillion ETL for Snowflake 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://snowflakesupport.matillion.com/customer/en/portal/topics/801885-transformation-component

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://snowflakesupport.matillion.com/customer/en/portal/topics/816489-orchestration-components

Connectors

40+ 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 Advances Variable System

SQS Integration

Post a message to an Amazon Simple Queue Service (SQS) queue. Other applications can read those messages and perform further processing.

Scripting in Bash and Python

Run a Bash or Python script

Component Generation Tooling

Load generator

Project Import/Export

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

Support for Altering Data Warehouse

Scale up and down your Data Warehouse in an orchestration

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.

Credential Management Using KMS

Matillion ETL can integrate with other platform-specific services in your account, provided you have authorised it to do so. This is not compulsory, although some parts of the product (such as S3 data loading) will not work without appropriate authorisation.

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 Managment

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.

Snowflake compatibility

Support any size/type of Snowflake 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.