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.
Automation Level Indicator: Displays the automation conversion coverage.
Status: Status of the ETL conversion stage.
Auto-Validation (Query): Displays the percentage of queries that have undergone syntax validation successfully.
User Feedback: Displays the auto conversion percentage based on your feedback.
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.

Browse through each script to get more insights into the transformations. In each transformation, you can see information about transformation status, type, automation level indicator, and more.

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.

In the Matillion ETL to Redshift and Airflow conversion, the orchestration jobs are transformed into the Airflow equivalent Python artifacts, whereas the transformation jobs are transformed into the Redshift equivalent SQL artifacts.

In the below image, you can see the orchestration jobs that are transformed to the Airflow equivalent Python artifacts.

In the below image, you can see the transformation jobs that are transformed to 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.