Matillion ETL Product Overview
    • Dark
      Light

    Matillion ETL Product Overview

    • Dark
      Light

    Article Summary

    Overview

    Matillion ETL is an ETL/ELT tool built specifically for cloud database platforms including Snowflake, Delta Lake on Databricks, Amazon Redshift, Google BigQuery, and Azure Synapse Analytics. Matillion ETL is a modern, browser-based UI, with powerful, push-down ETL/ELT functionality. With a fast setup, you are up and running in minutes.

    Matillion ETL:

    • Unlocks the power of your data warehouse: Matillion ETL pushes down data transformations to your cloud data warehouse, and processes millions of rows in seconds, with real-time feedback.
    • Offers a modern, browser-based environment: Including features such as collaboration, version control, full-featured graphical job development, and dozens of read, write, join, and transform components.
    • Is fast to set up: Launch and be developing ETL jobs within minutes.

    Matillion ETL UI


    Important features

    • Drag-and-drop browser interface. Build sophisticated, powerful ETL/ELT jobs.
    • Push-down ELT technology uses the power of your data warehouse to process complex joins over millions of rows in seconds.
    • Live feedback, validation, and data previews, inside the application, as you build your ETL/ELT jobs.
    • Collaboration baked-in. Build jobs together in different locations.
    • Version control, import/export, and server-side undo.
    • Over 80 out-of-the-box connectors to popular online services that you can connect to and pull your data from, not to mention the ability to create your own connector.
    • An easy-to-use user interface and basic functions so you can build your first job in minutes.
    • In-client support.
    • Enterprise features such as generated documentation.

    This documentation site explains:

    • How to find, launch, and connect to Matillion ETL.
    • How to use the product.
    • Each of the available components, with parameter reference, defaults, and notable unique behaviour.
    • Procedures, techniques, and best practices to get the most out of Matillion ETL.

    If you choose to register, you can raise questions in the moderated support forums and participate in discussion threads.


    Getting started

    Launching

    To get started with Matillion ETL, you need to decide which cloud platform and instance type of Matillion ETL is best for you. The instance type you select affects the maximum number of concurrent users who can access Matillion ETL and the maximum number of environments you can connect to.

    Check out our launch guides below or to discuss your options, or contact our sales team at sales@matillion.com.

    Connect to your instance

    Once you have launched Matillion ETL, you should be able to connect and start creating workflows in minutes. See the appropriate guide below for details on connecting to your instance:

    Creating a Project

    One of the first things to do on your new instance is to set up a project that contains your configurations and resources, such as jobs. Check out the below guide for help with sections detailing project creation for each flavour of Matillion ETL.

    Create your first project.

    Set up Credentials

    Your Matillion ETL instance needs to communicate with your cloud platform and data warehouse to perform its core functions. See the appropriate guide below on roles and permissions for your platform:

    Note

    Although setting up instance credentials like this is important to core functionality, Matillion ETL can also use services from other cloud platforms in a similar manner. See Manage Credentials for more information.

    We highly recommend browsing the rest of the Getting Started documentation category to make the best start with Matillion ETL.


    Videos

    Snowflake:

    Amazon Redshift:

    Google BigQuery:

    Azure Synapse Analytics: