Scripts - Files

This section shows information about the Script Files section of the Teradata Assessment Report.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

This page of the documentation is for Teradata only.

The Scripts - Files section of the assessment report for Teradata.

Conversion Rate - Files Generated

Indicates the file generation percentage grouped by valid file extension (shown in the image above).

You can refer to further information about this topic in the Conversion Rate Modes section of our documentation.

Formula

(successfully_generated_files / total_valid_files) * 100

Associated CSV Field names

• BTEQ Files Conversion Rate: BTEQFilesConversionRate

• FastLoad Files Conversion Rate: FastLoadFilesConversionRate

• MultiLoad Files Conversion Rate: MultiLoadFilesConversionRate

• TPT Files Conversion Rate: TPTFilesConversionRate

• TPump Files Conversion Rate: TPumpFilesConversionRate

Conversion Rate - Lines of Code (LOC)

Indicates the Lines of Code conversion percentage per file extension.

Formula

(successfully_converted_lines / total_line_amount_per_file_extension) * 100

Associated CSV Field names

• BTEQ LOC Conversion Rate: BTEQLoCConversionRate

• FastLoad LOC Conversion Rate: FastLoadLoCConversionRate

• MultiLoad LOC Conversion Rate: MultiLoadLoCConversionRate

• TPT LOC Conversion Rate: TPTLoCConversionRate

• TPump LOC Conversion Rate: TPumpLoCConversionRate

Total File Quantity

Indicates the total amount of files of each type. It is used to calculate the Files Generated conversion rate.

Associated CSV Field names

• BTEQ Total File Quantity: BTEQFileCount

• FastLoad Total File Quantity: FastLoadFileCount

• MultiLoad Total File Quantity: MultiLoadFileCount

• TPT Total File Quantity: TPTFileCount

• TPump Total File Quantity: TPumpFileCount

Sample

Input

input folder
  ├> one.bteq
  ├> two.tpt
  ├> three.doc
  └> readme.txt

Output

From the previous, we will get:

• Number of BTEQ files: 1

• Number of TPT files: 1

Total LOC

Indicates the total amount of lines of code per file extension. It is used to calculate the Lines of Code conversion..

Associated CSV Field names

• BTEQ Total LOC: BTEQLinesCount

• FastLoad Total LOC: FastLoadLinesCount

• MultiLoad Total LOC: MultiLoadLinesCount

• TPT Total LOC: TPTLinesCount

• TPump Total LOC: TPumpLinesCount

Indicates the total amount of parsing errors per file extension.

Associated CSV Field names

• BTEQ Total Parsing Errors: BTEQTotalParsingErrors

• FastLoad Total Parsing Errors: FastLoadTotalParsingErrors

• MultiLoad Total Parsing Errors: MultiLoadTotalParsingErrors

• TPT Total Parsing Errors: TPTTotalParsingErrors

• TPump Total Parsing Errors: TPumpTotalParsingErrors

Sample

Input TPT File

IN -> Teradata_01.tpt

CREATE TABLE TABLE_INVALID [
  first_column INTEGER
];

Output

Explanation: In the example below, there is a parsing error when creating the table due to the incorrect use of the square brackets ([]), lines 1 and 3. This will be shown in the report as 1 parsing error in the TPT files row.