SnowConvert: SQL Conversion Summary¶

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.

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.

SELECT 123 FROM my_table;

SELECT 123
FROM my_table;

SELECT 123
FROM my_table;

Unrecognized statement

SELECT '123

abc' FROM my_table;

invalid '

' code

-- Hello world

/* hello

world */

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.

sql_converted_lines_of_code / sql_total_lines_of_code

CREATE TABLE t1
(
col1 INTEGER
);

CREATE TABLE t1
(
NOT A VALID ELEMENT
);

CREATE TABLE t1 (
NOT A VALID ELEMENT );

CREATE TABLE t1 (
  col1 INTEGER
);

SELECT CAST (123 AS INTERVAL DAY(4));

-- Hello world
Unrecognized statement

Unrecognized Lines of Code¶

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.