Project Menu

Create Project

5 Articles in this category

Manage Functions

14 Articles in this category

Queue Messaging

3 Articles in this category

CDC

3 Articles in this category

Git Integration

7 Articles in this category

Switch Project

Overview A Matillion ETL project is a logical grouping of configuration settings and jobs. All work carried out in Matillion ETL will be within the scope of a specific project, and a given Matillion ETL instance may contain multiple projects...

Updated on : 05 May 2022

Using Data Structure Variables

Overview The data structure variable type lets users dynamically populate parameters that require a structured object. Users can then parameterize and automate their jobs that extract and flatten nested data. The data structure variable ac...

Updated on : 05 May 2022

Change My Password

Overview Matillion ETL users can change their login password using the following steps: 1. Click Project → Change My Password . 2. Complete the three fields in the Change Password dialog. Property Description ...

Updated on : 05 May 2022

Extract To New Job

Overview Extract To New Job is a feature of the Matillion ETL client that allows users to take an arbitrary selection arbitrary components in a job and use them to create a new standalone job. This new job then takes the place of the selected com...

Updated on : 05 May 2022

Historical Jobs

Overview Historical Jobs allows users—through their task history—to view how a job was set up at the time of running. The task history records each job exactly as it was when the job was running, including the job's layout, notes, and compon...

Updated on : 05 May 2022

Import - Export

Overview Jobs, environments, and variables can be exported from one Matillion ETL instance to be imported into another. One way of accomplishing this is through the API . You can also use the Export and Import overlays, accessed thro...

Updated on : 05 May 2022

Input Data Report

Overview The Input Data Report can be found through the menu Project Input Data Report. Using this, users can quickly reference what columns are used with each of their Transformation jobs and identify which components are working cor...

Updated on : 05 May 2022

Manage Error Reporting

Overview Error reporting allows you to post a message to a webhook if an error occurs in a component or job, resulting in a failure of a job run. Error reporting can be enabled for either the project group instance, or on a per project ba...

Updated on : 05 May 2022

Project User Access

Overview This is a step-by-step guide to modifying user access permissions for projects within a Matillion ETL instance. Follow the instructions given below to modify the user access permissions. Important Information Users responsib...

Updated on : 05 May 2022

Recycle Bin

Overview When a Matillion ETL user deletes an Orchestration Job or a Transformation Job, the job is moved to the Recycle Bin rather than being removed completely. You can access the Recycle Bin from the Project menu to restore or "Delete For...

Updated on : 13 May 2022

Job Reference Renaming

Overview Matillion ETL lets users rename orchestration jobs and transformation jobs. Additionally, as of version 1.58, users can select whether the renaming of a job renames all instances where that job is referenced, or not. Read below fo...

Updated on : 05 May 2022

Job References

Overview The References tab in Matillion ETL lets users see where a job, Shared Job, or component is being used or referenced by another job. The References tab lists all referents and includes a URL path so that users can quickly navigate t...

Updated on : 05 May 2022

How to Retrieve Missing Task History Entries After 1.47 upgrade

Overview Following a Postgres update, from version 1.47 of Matillion ETL onwards, only a subset of the whole task history will be immediately available without user action. This subset is a maximum of the most recent 500,000 rows. For example...

Updated on : 05 May 2022

Loading Task Information

Overview It can be useful to take the task information from Matillion ETL and load it into a table and/or to preserve it on in file storage, allowing the user to run diagnostic or logistical analysis of the jobs that have been run. Task Inform...

Updated on : 05 May 2022