File and Object Level Breakdown - SQL Files
This section shows a general conversion summary for all the SQL files.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
In Teradata, this table applies to all the files with the following extensions:
.sql
.dml
.ddl
Code Conversion Rate
This section shows the code conversion rate of the SQL files. For more information about these calculations check the Conversion Rate Modes section.
Formula
CSV Associated Field Names
SqlLoCConversionRate
Sample
Consider the following example, even though the second table is not recognized due to a parsing error, the comments inside are considered supported lines of code.
Expected Conversion Rate: 65%
Explanation: There is a total of 20 lines of code, and 13 of them were successfully converted by the tool. Using the formula, the conversion rate is (13/20)*100.
A line with an error is defined as every line of code that contains at least one error message. For more information check the Issues and Troubleshooting section of each language documentation.
Conversion Rate - Files Generated
This field applies only to Teradata reports.
It describes the percentage of SQL files that were successfully generated. The files that were not generated in the output are due to unexpected issues during the process of transformation.
Formulae
CSV Associated Field Names
SqlFilesConversionRate
Sample
Expected Files Generated Conversion Rate: 66.67%
Explanation: Only 2 of the 3 input files of the conversion were successfully generated in the output.
Conversion Rate - LOC
This field applies only to Teradata reports.
It describes the same as the Code Conversion Rate common section but applies to all the supported SQL file extensions in Teradata.
Total File Quantity
This field applies only to Teradata reports.
It describes the total number of identified SQL files.
CSV Associated Field Names
SqlFileCount
Sample
Expected Total File Quantity: 3
Explanation: In this sample, 3 of the files have a supported SQL extension.
Total LOC
This field applies only to Teradata reports.
It describes the same as the Lines of Code common section but applies to all the supported SQL file extensions in Teradata.
Lines of Code
It represents the number of lines of code in the SQL extension files. This counting does not consider blank lines, only the ones that contain code, comments, or both.
CSV Associated Field Names
SqlLinesCount
Sample
Expected Lines of code: 55
Explanation: Only the lines in the SQL extension files are considered in this section.
Total Object Quantity
It describes the number of objects successfully identified in the SQL extension files.
CSV Associated Field Names
SqlIdentifiedObjects
Sample
Expected Identified Objects: 1
Explanation: There are two CREATE TABLE
statements in this example. The first one is fully recognized since it is parsed correctly, but the second one has two misspelled words in the definition so it is not recognized by Snow Convert.
Parsing Errors
This section shows the total number of unrecognized fragments of code in the SQL files.
CSV Associated Field Names
SqlTotalParsingErrors
Sample
Expected Parsing Errors: 3
Explanation: There are two parsing errors inside the first table and the second table is considered a whole parsing error due to the misspelled keyword.
Last updated