SnowConvert AI - File and Object Level Breakdown - SQL Identified Objects

Oracle 评估报告的“SQL - 已识别对象”部分。

转换率 - 对象

备注

如果对象没有中等、高或严重的问题，则认为该对象已成功迁移。

Represents the percentage of identified objects by SnowConvert AI that were successfully migrated. This will help to determine the number of objects that were successfully migrated and the objects that need manual work in order to complete the migration of the objects to Snowflake. If N/A is listed in the column, it means that the object type is not supported in Snowflake. A "-" could also be listed in this column, this means that the set of files migrated by SnowConvert AI did not contain objects of the specific type that could be identified.

公式

(successfully_converted_objects / total_object_quantity) * 100
Copy

CSV 关联的字段名称

  • 所有语言

    • 表： SqlTableObjectConversionRate

    • 视图： SqlViewObjectConversionRate

    • 过程： SqlProcedureObjectConversionRate

    • 函数： SqlFunctionObjectConversionRate

    • 触发器：SqlTriggerObjectConversionRate

    • 索引： 不适用

  • Teradata

    • 宏： SqlMacroObjectConversionRate

    • 联接索引： SqlJoinIndexObjectConversionRate

  • Oracle

    • 包： SqlPackageObjectConversionRate

    • 包体： SqlPBodyObjectConversionRate

    • 序列： SqlSequenceObjectConversionRate

    • 同义词： SqlSynonymObjectConversionRate

    • 类型： SqlTypeObjectConversionRate

    • ** DB 链接：** 不适用

    • 物化视图： SqlMaterializedObjectConversionRate

  • SQLServer

    • 物化视图： SqlMaterializedObjectConversionRate

示例

-- Table that is migrated successfully to Snowflake.
CREATE TABLE table1 (
  col1 INTEGER
);

-- Table that is not migrated successfully to Snowflake because of the data type of col1.
CREATE TABLE table2 (
  col1 ANYTYPE
);
Copy

预期对象转换率： 50%

解释： 根据之前的示例代码，我们的对象转换率将达到 50%，因为 2 个已识别表中只有 1 个成功迁移到 Snowflake。

转换率 – 代码

Represents the percentage of lines or characters of code of the top-level object that were successfully migrated. You can read more about the different conversion rate modes and how they are calculated by SnowConvert AI here.

CSV 关联的字段名称

备注

在 Assessment.csv 报告中，每个顶级对象都有两个代码转换率字段。一个是使用代码行数计算的转换率，另一个是使用字符数计算。

  • 所有语言：

    • 表

      • 代码行数 SqlTableLoCConversionRate

      • 字符数： SqlTableCharacterConversionRate

    • 视图

      • 代码行数 SqlViewLoCConversionRate

      • 字符数： SqlViewCharacterConversionRate

    • 过程

      • 代码行数 SqlProcedureLoCConversionRate

      • 字符数： SqlProcedureCharacterConversionRate

    • 函数

      • 代码行数 SqlFunctionLoCConversionRate

      • 字符数： SqlFunctionCharacterConversionRate

    • 索引

      • 代码行数： 不适用

      • 字符数： 不适用

    • 触发器

      • 代码行数 SqlTriggerLoCConversionRate

  • Teradata

    • 宏

      • 代码行数 SqlMacroLoCConversionRate

      • 字符数： SqlMacroCharacterConversionRate

    • 联接索引

      • 代码行数 SqlJoinIndexLoCConversionRate

      • 字符数： SqlJoinIndexCharacterConversionRate

  • Oracle

    • 物化视图

      • 代码行数 SqlMaterializedViewLoCConversionRate

      • 字符数： SqlMaterializedViewCharacterConversionRate

    • 包

      • 代码行数 SqlPackageLoCConversionRate

      • 字符数： SqlPackageCharacterConversionRate

    • 包体

      • 代码行数 SqlPBodyLoCConversionRate

      • 字符数： SqlPBodyCharacterConversionRate

    • 序列

      • 代码行数 SqlSequenceLoCConversionRate

      • 字符数： SqlSequenceCharacterConversionRate

    • 同义词

      • 代码行数 SqlSynonymLoCConversionRate

      • 字符数： SqlSynonymCharacterConversionRate

    • 类型

      • 代码行数 SqlTypeLoCConversionRate

      • 字符数： SqlTypeCharacterConversionRate

  • SQLServer

    • 物化视图

      • 代码行数 SqlMaterializedViewLoCConversionRate

      • 字符数： SqlMaterializedViewCharacterConversionRate

示例

CREATE TABLE table1 (
  col1 INTEGER
);
CREATE TABLE table2 (
  col1 ANYTYPE
);
Copy

预期代码转换率： 83.33%

Explanation: In the previous sample code, there are two CREATE TABLE statements and SnowConvert AI is executed using lines of code to calculate the code conversion rate. table1 was successfully migrated but table2 was not migrated completely, in this case, line 5 of the input code could not be migrated and only 5 of the 6 total lines of code were migrated successfully. This calculation will generate a conversion rate for tables of 83.33%.

代码行数

表示用于已识别顶级对象的总代码行数。需要特别注意的是，顶层对象的代码行数以及注释都会用于此列。另一方面，空行不会计入此列。

CSV 关联的字段名称

  • 所有语言

    • 表： SqlTableTotalLinesOfCode

    • 视图： SqlViewTotalLinesOfCode

    • 过程： SqlProcedureTotalLinesOfCode

    • 函数： SqlFunctionTotalLinesOfCode

    • 索引： SqlIndexTotalLinesOfCode

    • 触发器： SqlTriggerTotalLinesOfCode

  • Teradata

    • 宏： SqlMacroTotalLinesOfCode

    • 联接索引： SqlJoinIndexTotalLinesOfCode

  • Oracle

    • 包： SqlPackageTotalLinesOfCode

    • 包体： SqlPBodyTotalLinesOfCode

    • 序列： SqlSequenceTotalLinesOfCode

    • 同义词： SqlSynonymTotalLinesOfCode

    • 类型： SqlTypeTotalLinesOfCode

    • DB 链接： SqlDbLinkTotalLinesOfCode

    • 物化视图： SqlMaterializedViewTotalLinesOfCode

  • SQLServer

    • 物化视图： SqlMaterializedViewTotalLinesOfCode

示例

-- Hello World
CREATE TABLE table1 (
  col1 INTEGER
);

CREATE TABLE table2 (
-- Hello world 2
  col1 ANYTYPE
);
Copy

预期代码行数： 8

解释： 在这种情况下，来自 CREATE TABLE 语句的代码占 6 行，而顶层对象内包含的注释占 2 行。

对象总数

Represents the total amount of objects identified by SnowConvert AI during the parsing phase.

CSV 关联的字段名称

  • 所有语言

    • 表： SqlTableTotalOccurrences

    • 视图： SqlViewTotalOccurrences

    • 过程： SqlProcedureTotalOccurrences

    • 函数： SqlFunctionTotalOccurrences

    • 索引： SqlIndexTotalOccurrences

    • 触发器： SqlTriggerTotalOccurrences

  • Teradata

    • 宏： SqlMacroTotalOccurrences

    • 联接索引： SqlJoinIndexTotalOccurrences

  • Oracle

    • 包： SqlPackageTotalOccurrences

    • 包体： SqlPBodyTotalOccurrences

    • 序列： SqlSequenceTotalOccurrences

    • 同义词： SqlSynonymTotalOccurrences

    • 类型： SqlTypeTotalOccurrences

    • DB 链接： SqlDbLinkTotalOccurrences

    • 物化视图： SqlMaterializedViewTotalOccurrences

  • SQLServer

    • 物化视图： SqlMaterializedViewTotalOccurrences

示例

-- Successfully parsed table.
CREATE TABLE table1 (
  col1 INTEGER
);

-- Table with a parsing error that could not be identified.
CRATE TABLE table2 (
  col1 INTEGER
);
Copy

预期对象总数： 1。

Explanation: One table was completely parsed by SnowConvert AI during the parsing phase but the other table has a parsing error that causes SnowConvert AI to not identify it as a table object.

解析错误

表示每种顶级对象类型的已识别对象内部的解析错误数量。

CSV 关联的字段名称

  • 所有语言

    • 表： SqlTableTotalParsingErrors

    • 视图： SqlViewTotalParsingErrors

    • 物化视图： SqlMaterializedViewTotalParsingErrors

    • 过程： SqlProcedureTotalParsingErrors

    • 函数： SqlFunctionParsingErrors

    • 触发器： SqlTriggerTotalParsingErrors

    • 索引： SqlIndexTotalParsingErrors

  • Teradata

    • 宏： SqlMacroTotalParsingErrors

    • 联接索引： SqlJoinIndexTotalParsingErrors

  • Oracle

    • 包： SqlPackageTotalParsingErrors

    • 包体： SqlPBodyTotalParsingErrors

    • 序列： SqlSequenceTotalParsingErrors

    • 同义词： SqlSynonymTotalParsingErrors

    • 类型： SqlTypeTotalParsingErrors

    • DB 链接： SqlDbLinkTotalParsingErrors

    • 物化视图： SqlMaterializedViewTotalParsingErrors

  • SQLServer

    • 物化视图： SqlMaterializedViewTotalParsingErrors

示例

-- Table with parsing error but still was identified by SnowConvert.
CREATE TABLE table1 (
  col3 NUMBER,
);

-- Table with parsing error but was not identified by SnowConvert.
CRATE TABLE table2 (
  col1 INTEGER
);
Copy

预期解析错误数： 1

Explanation: Only one parsing error will be reported in the Parsing Errors column because SnowConvert AI was able to only identify the first table. Since the second table was not identified, those parsing errors will not be counted in the Parsing Errors column.

语言: 中文