The conversion rate is the percentage of the total source code that was successfully converted by SnowConvert into functionally equivalent Snowflake code. Every time that SnowConvert identifies not supported elements, i.e, fragments in the input source code that were not converted into Snowflake, this will affect the conversion rate. You can read more about the different conversion rate modes and how they are calculated by SnowConvert .
CSV Associated Field Names
The CSV field associated is going to depend on the conversion rate mode used.
Code Conversion Rate:
SqlLoCConversionRate
SqlCharacterConversionRate
Lines of Code
This field applies only to Teradata reports.
Represents the number of lines of code found in the SQL files. This counting includes comments but does not include empty lines or lines with only whitespaces unless they are inside block comments or strings. Lines of code that were not recognized are counted as well.
Samples
SELECT 123 FROM my_table;
Expected Lines of Code: 1
SELECT 123
FROM my_table;
Expected lines of code: 2
SELECT 123
FROM my_table;
Unrecognized statement
Expected lines of code: 3
SELECT '123
abc' FROM my_table;
Expected lines of code: 3
Explanation: In this case, we have an empty line inside a string. Since this is part of the selected string, is considered part of the code and is counted as a line of code.
invalid '
' code
Expected lines of code: 3
Explanation: In this case, even if the code was not recognized, there was still a string containing the empty line. Such cases will count the empty line of code as well.
-- Hello world
Expected Lines of Code: 1
/* hello
world */
Expected Lines of Code: 3
Explanation: In this case, the second line is part of the block comment in the example, so this is counted as one line of code as well.
CSV Associated Field Names
SqlLinesOfCode
LOC Conversion Percentage
This field applies only to Teradata reports.
This is the percentage of fully converted lines divided by the total lines of code. Unrecognized Lines of code count as not converted. Comments count as converted.
Elements that contain an EWI with medium severity or higher will count as not converted. These elements may include more than one line depending on how the input code was formatted.
Explanation: The entire table is supported. Because of this, the conversion rate is 100%.
CREATE TABLE t1
(
NOT A VALID ELEMENT
);
Expected LOC Conversion Percentage: 75%
Explanation: In this case, the third line is unrecognized. The other 3 lines are identified and converted properly, causing a conversion rate of 75%.
CREATE TABLE t1 (
NOT A VALID ELEMENT );
Expected LOC Conversion Percentage: 50%
Explanation: Even though this is the same code as Sample 2, the format of the code is different. In this case, the first line is considered converted, and the second line has an unrecognized part, causing the line to be counted as not supported. Because of this, the conversion rate is 50%.
Explanation: In this case, the 3 lines of the CREATE TABLE are supported, but the SELECT has a CAST to INTERVAL which is not supported, causing line 5 to be counted as unsupported.
-- Hello world
Unrecognized statement
Expected LOC Conversion Percentage: 50%
Explanation: In this case, the first line comment is considered as converted and the second line, an unrecognized element, is not supported, causing a 50% conversion rate.
CSV Associated Field Names
SqlLoCConversionRate
Unrecognized Lines of Code
This field applies only to Teradata reports.
This is the number of lines of code that had an element that was not recognized.
Unrecognized Element
Unrecognized Lines of Code: 1
invalid '
' something
Unrecognized Lines of Code: 3
Explanation: In this case, there is a string that starts at line 1 and ends at line 3. However, the entire block of code was not recognized, causing the 3 lines to be counted as unrecognized lines of code.
Expected Lines of Code: 1