Matillion Conversion Report

This topic provides a comprehensive report on Matillion ETL conversion. The ETL conversion pipeline converts legacy Matillion ETL workloads to modern AWS cloud platforms.

This section provides an overview of the ETL conversion, which includes:

Script Type: Displays the source and target data sources of the ETL transformation.
Total Jobs: Displays the total number of jobs along with the number of orchestration and transformation jobs.
Total Components: Displays the total number of components along with the number of orchestration and transformation components.
Job Transformed: Displays the number of successful and failed orchestration and transformation jobs.
Automatic Conversion Rate: Provides the percentage of automatic conversion.
Status: Status of the ETL conversion stage.
Description: A brief description of the stage is displayed.

In This Topic:

Scripts
Package

Scripts

This topic shows a comprehensive report of the converted artifacts. The left panel lists all the input files along with the file-wise transformation percentage. The right panel shows information about the selected file. It includes information about the jobs, job type, components, and auto-conversion rate along with the status and success or failure messages. The failure message helps you understand the error and guides you to fix it.

Package

This topic provides a detailed report of the converted artifacts in Python and SQL file formats which can be directly consumed on the target platform. Select to download the converted artifacts for offline use.

The Matillion ETL conversion stage transforms orchestration and transformation jobs to target equivalent jobs (Amazon Redshift + Apache Airflow). The orchestration jobs are transformed into the Airflow equivalent Python artifacts, whereas the transformation jobs are transformed into the Redshift equivalent SQL artifacts.

Moreover, the TODO file displays messages regarding all unsupported components or queries that cannot auto-convert and require manual intervention.