SQL Conversion Summary
This section shows the SQL conversion summary
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Code Conversion Rate
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 here.
CSV Associated Field Names
Code Conversion Rate:
SqlLoCConversionRate
SqlCharacterConversionRate
Lines of Code
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 statementExpected 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 '
' codeExpected 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: 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 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.
Formula
sql_converted_lines_of_code / sql_total_lines_of_codeSamples
CREATE TABLE t1
(
col1 INTEGER
);Expected LOC Conversion Percentage: 100%
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%.
CREATE TABLE t1 (
col1 INTEGER
);
SELECT CAST (123 AS INTERVAL DAY(4));Expected LOC Conversion Percentage: 75%
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 statementExpected 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 is the number of lines of code that had an element that was not recognized.
Unrecognized ElementUnrecognized Lines of Code: 1
invalid '
' somethingUnrecognized 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.
CSV Associated Field Names
SqlUnrecognizedElementsLOC
Last updated
Expected Lines of Code: 1