Code Completeness Score

This section shows the Code Completeness Score.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

The Code Completeness Score section of the assessment report for Teradata

Code Completeness Score Value

This number represents the percentage of code units whose references to other code units are correctly addressed by SnowConvert. If the score is less than one hundred represents that there is at least one code unit referencing one or more code units not included in the source code.

Formula

((total_CU - impacted_CU) / total_CU ) * 100

total_CU = total number of Code Units
impacted_CU = Code Units with missing references

Sample

Input

IN -> Teradata_01.sql

-- Code Unit with no missing references
CREATE TABLE table1
(
    COL1 VARCHAR
)

-- Code Unit with no missing references
SELECT * from table1;

-- Code Unit with a missing reference
SELECT * from missing_table;

Output

OUT -> Teradata_01.sql

-- Code Unit with no missing references
CREATE OR REPLACE TABLE table1
(
    COL1 VARCHAR
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;

-- Code Unit with no missing references
SELECT
* from
table1;

-- Code Unit with a missing reference
SELECT
* from
missing_table;

Expected Code Completeness Score: 66.67

Explanation: In this case, we have 3 code units and only one of them has a missing reference. The SELECT in line 11 references another code unit called 'missing_table' whose definition is not present in the source code, therefore this SELECT is considered a code unit with missing references.