SnowConvert AI - Assessment Report¶

一般摘要¶

The purpose of this document is to provide guidance for users to understand the summary results from the SnowConvert AI conversion tools. It will guide through the different metrics returned and how these metrics can be used to determine the automation level achieved, and the amount of manual effort needed to make the output code into functionally equivalent Snowflake code.

本文档中呈现的大部分概念在报告首页中已有解释。但是，以下是有关上图中最重要信息的进一步说明：

• 总解析错误数：表示转换工具在转换过程中发现无法识别为语法正确的源语言元素的文本片段的次数。解析错误的影响可大可小。重要的是要确定受解析错误影响的 LOC 及其在总工作负载中的占比。有时，解析错误可能是由于编码问题或工作负载尚需预处理所致。

• Code Conversion Rate: The conversion rate is the percentage of the total source code that was successfully converted by SnowConvert AI into functionally equivalent Snowflake code. Every time that the tool identifies not supported elements, i.e, fragments in the input source code that were not converted into Snowflake, this will affect the conversion rate.

• Identified Objects: The count of all the Top Level DDL Objects ( Table, View, Procedure, etc.. ) that the SnowConvert AI identified. If there were a parsing error on an object, it wouldn't be an Identified Object.
  Example: The first objects from line #1 to line #6. There is evidently a parsing error, so the SnowConvert AI cannot identify that as an object.

--Comment123
CREATE TABLE Table1(
 Prefix_Employee_Name CHAR(25),
 !ERROR_Col,
 Prefix_Employee_Sal DECIMAL(8))

--Comment123
CREATE OR REPLACE TABLE Table1 (
 Prefix_Employee_Name CHAR(25)
--                              ,
-- ** SSC-EWI-0001 - UNRECOGNIZED TOKEN ON LINE '4' COLUMN '2' OF THE SOURCE CODE STARTING AT '!'. EXPECTED 'Column Definition' GRAMMAR. LAST MATCHING TOKEN WAS ',' ON LINE '3' COLUMN '31'. FAILED TOKEN WAS '!' ON LINE '4' COLUMN '2'. CODE '15'. **
-- !ERROR_Col
           ,
 Prefix_Employee_Sal DECIMAL(8))
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"teradata"}}'
;

--Comment123 /*12 code characters*/
CREATE TABLE Table1( /*18 code characters*/
 Prefix_Employee_Name CHAR(25), /*29 code characters*/
 !ERROR_Col, /*11 code characters*/
 Prefix_Employee_Sal DECIMAL(8)) /*30 code characters*/

SELECT col1, !error_col FROM table1;
```
```none
SELECT
   col1,
   !error_col
 FROM
    table1;

文件和对象级细分¶

问题分解¶

在此页面中，您将看到唯一问题的数量以及按严重程度降序排列的问题列表。

例如，对于给定的源代码，有 2 个与解析错误相关的严重问题，以及一个与 Not supported function 函数相关的中等严重性问题。