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

Der Abschnitt „SQL - Identified Objects“ des Bewertungsberichts für Oracle

Conversion Rate - Object

Bemerkung

Ein Objekt gilt als erfolgreich migriert, wenn es keine Probleme mit mittlerem, hohem oder kritischem Schweregrad aufweist.

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.

Formel

(successfully_converted_objects / total_object_quantity) * 100
Copy

Zu CSV zugeordnete Feldnamen

  • Alle Sprachen

    • Tables: SqlTableObjectConversionRate

    • Views: SqlViewObjectConversionRate

    • Procedures: SqlProcedureObjectConversionRate

    • Functions: SqlFunctionObjectConversionRate

    • Triggers: SqlTriggerObjectConversionRate

    • Indexes: N/A

  • Teradata

    • Macros: SqlMacroObjectConversionRate

    • Join Indexes: SqlJoinIndexObjectConversionRate

  • Oracle

    • Packages: SqlPackageObjectConversionRate

    • Packages Bodies: SqlPBodyObjectConversionRate

    • Sequences: SqlSequenceObjectConversionRate

    • Synonyms: SqlSynonymObjectConversionRate

    • Types: SqlTypeObjectConversionRate

    • DB Link: N/A

    • Materialized Views: SqlMaterializedObjectConversionRate

  • SQLServer

    • Materialized Views: SqlMaterializedObjectConversionRate

Beispiel

-- 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

Erwartete Objektkonvertierungsrate: 50 %

Erläuterung: Mit dem obigen Beispielcode haben wir eine Objektkonvertierungsrate von 50 %, da nur 1 der 2 identifizierten Tabellen erfolgreich nach Snowflake migriert wurde.

Conversion Rate - Code

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.

Zu CSV zugeordnete Feldnamen

Bemerkung

Jedes Objekt der obersten Ebene hat im Bericht Assessment.csv zwei Felder für die Codekonvertierungsrate. Eines ist für die Konvertierungsrate anhand der Codezeilen und das andere für die Konvertierungsrate anhand der Zeichen.

  • Alle Sprachen:

    • Tabellen

      • Lines of Code: SqlTableLoCConversionRate

      • Characters: SqlTableCharacterConversionRate

    • Views

      • Lines of Code: SqlViewLoCConversionRate

      • Characters: SqlViewCharacterConversionRate

    • Procedures

      • Lines of Code: SqlProcedureLoCConversionRate

      • Characters: SqlProcedureCharacterConversionRate

    • Functions

      • Lines of Code: SqlFunctionLoCConversionRate

      • Characters: SqlFunctionCharacterConversionRate

    • Indexes

      • Lines of Code: N/A

      • Characters: N/A

    • Triggers

      • Lines of Code: SqlTriggerLoCConversionRate

  • Teradata

    • Macros

      • Lines of Code: SqlMacroLoCConversionRate

      • Characters: SqlMacroCharacterConversionRate

    • Join Indexes

      • Lines of Code: SqlJoinIndexLoCConversionRate

      • Characters: SqlJoinIndexCharacterConversionRate

  • Oracle

    • Materialized Views

      • Lines of Code: SqlMaterializedViewLoCConversionRate

      • Characters: SqlMaterializedViewCharacterConversionRate

    • Packages

      • Lines of Code: SqlPackageLoCConversionRate

      • Characters: SqlPackageCharacterConversionRate

    • Package Bodies

      • Lines of Code: SqlPBodyLoCConversionRate

      • Characters: SqlPBodyCharacterConversionRate

    • Sequences

      • Lines of Code: SqlSequenceLoCConversionRate

      • Characters: SqlSequenceCharacterConversionRate

    • Synonyms

      • Lines of Code: SqlSynonymLoCConversionRate

      • Characters: SqlSynonymCharacterConversionRate

    • Types

      • Lines of Code: SqlTypeLoCConversionRate

      • Characters: SqlTypeCharacterConversionRate

  • SQLServer

    • Materialized Views

      • Lines of Code: SqlMaterializedViewLoCConversionRate

      • Characters: SqlMaterializedViewCharacterConversionRate

Beispiel

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

Erwartete Codekonvertierungsrate: 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%.

Lines of Code

Stellt die Gesamtzahl der Codezeilen dar, die für die identifizierten Objekte der obersten Ebene verwendet wurden. Es ist wichtig zu beachten, dass die Codezeilen des Objekts der obersten Ebene sowie die Kommentare für diese Spalte verwendet werden. Leere Zeilen hingegen werden in dieser Spalte nicht gezählt.

Zu CSV zugeordnete Feldnamen

  • Alle Sprachen

    • Tables: SqlTableTotalLinesOfCode

    • Views: SqlViewTotalLinesOfCode

    • Procedures: SqlProcedureTotalLinesOfCode

    • Functions: SqlFunctionTotalLinesOfCode

    • Indexes: SqlIndexTotalLinesOfCode

    • Triggers: SqlTriggerTotalLinesOfCode

  • Teradata

    • Macros: SqlMacroTotalLinesOfCode

    • Join Indexes: SqlJoinIndexTotalLinesOfCode

  • Oracle

    • Packages: SqlPackageTotalLinesOfCode

    • Packages Bodies: SqlPBodyTotalLinesOfCode

    • Sequences: SqlSequenceTotalLinesOfCode

    • Synonyms: SqlSynonymTotalLinesOfCode

    • Types: SqlTypeTotalLinesOfCode

    • DB Link: SqlDbLinkTotalLinesOfCode

    • Materialized Views: SqlMaterializedViewTotalLinesOfCode

  • SQLServer

    • Materialized Views: SqlMaterializedViewTotalLinesOfCode

Beispiel

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

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

Erwartete Anzahl von Codezeilen: 8

Erläuterung: In diesem Fall haben wir 6 Zeilen, die aus dem Code für die CREATE TABLE-Anweisungen stammen, und 2 für Kommentare, die sich innerhalb der Objekte der obersten Ebene befinden.

Total Object Quantity

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

Zu CSV zugeordnete Feldnamen

  • Alle Sprachen

    • Tables: SqlTableTotalOccurrences

    • Views: SqlViewTotalOccurrences

    • Procedures: SqlProcedureTotalOccurrences

    • Functions: SqlFunctionTotalOccurrences

    • Indexes: SqlIndexTotalOccurrences

    • Triggers: SqlTriggerTotalOccurrences

  • Teradata

    • Macros: SqlMacroTotalOccurrences

    • Join Indexes: SqlJoinIndexTotalOccurrences

  • Oracle

    • Packages: SqlPackageTotalOccurrences

    • Packages Bodies: SqlPBodyTotalOccurrences

    • Sequences: SqlSequenceTotalOccurrences

    • Synonyms: SqlSynonymTotalOccurrences

    • Types: SqlTypeTotalOccurrences

    • DB Link: SqlDbLinkTotalOccurrences

    • Materialized Views: SqlMaterializedViewTotalOccurrences

  • SQLServer

    • Materialized Views: SqlMaterializedViewTotalOccurrences

Beispiel

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

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

Erwartete Gesamtobjektmenge: 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.

Parsing Errors

Stellt die Anzahl der Parsing-Fehler dar, die sich innerhalb der identifizierten Objekte jedes Objekttyps der obersten Ebene befinden.

Zu CSV zugeordnete Feldnamen

  • Alle Sprachen

    • Tables: SqlTableTotalParsingErrors

    • Views: SqlViewTotalParsingErrors

    • Materialized Views: SqlMaterializedViewTotalParsingErrors

    • Procedures: SqlProcedureTotalParsingErrors

    • Functions: SqlFunctionParsingErrors

    • Triggers: SqlTriggerTotalParsingErrors

    • Indexes: SqlIndexTotalParsingErrors

  • Teradata

    • Macros: SqlMacroTotalParsingErrors

    • Join Indexes: SqlJoinIndexTotalParsingErrors

  • Oracle

    • Packages: SqlPackageTotalParsingErrors

    • Packages Bodies: SqlPBodyTotalParsingErrors

    • Sequences: SqlSequenceTotalParsingErrors

    • Synonyms: SqlSynonymTotalParsingErrors

    • Types: SqlTypeTotalParsingErrors

    • DB Link: SqlDbLinkTotalParsingErrors

    • Materialized Views: SqlMaterializedViewTotalParsingErrors

  • SQLServer

    • Materialized Views: SqlMaterializedViewTotalParsingErrors

Beispiel

-- 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

Erwartete Parsing-Fehler: 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.