SQL Conversion Summary

This section shows the SQL conversion summary

Code Conversion Rate

This field applies to Oracle and SQLServer

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

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

-- Hello world

Expected Lines of Code: 1

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.

Formula

sql_converted_lines_of_code / sql_total_lines_of_code

Samples

CREATE TABLE t1
(
col1 INTEGER
);

Expected LOC Conversion Percentage: 100%

Explanation: The entire table is supported. Because of this, the conversion rate is 100%.

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

CSV Associated Field Names

  • SqlUnrecognizedElementsLOC

Last updated