Scripts - Identified Objects

This section shows the Script Files conversion summary of Teradata Assessment Report.

This page of the documentation is for Teradata only.

The breakdown of all the database objects created or modified in all script files (BTEQ, BTQ, FL, ML, TPUMP, TPT).

Conversion Rate - Object

An object is considered successfully migrated if it does not have issues with medium, high, or critical severity.

Represents the percentage of identified objects by SnowConvert 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 did not contain objects of the specific type that could be identified.

Formula

(successfully_converted_scripts_objects / total_scripts_objects) * 100

CSV Associated Field Names

  • Tables: ScriptTableObjectConversionRate

  • Views: ScriptViewObjectConversionRate

  • Join Index: ScriptJoinIndexObjectConversionRate

  • Macro: ScriptMacroObjectConversionRate

  • Procedures: ScriptProcedureObjectConversionRate

  • Functions: ScriptFunctionObjectConversionRate

  • Triggers: ScriptTriggerObjectConversionRate

  • Indexes: N/A

Sample

IN -> Teradata_01.btq
-- Additional Params: -q SnowScript
CREATE SET TABLE Tables_Database.Employee
   (Associate_Id     INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);

CRATE SET TABLE Tables_Database.Employee2
   (Associate_Id     INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);

Expected Object Conversion Rate: 50%

Explanation: With the previous sample code we will have a 50% Object Conversion Rate because only 1 of the 2 identified tables were successfully migrated to Snowflake.

Conversion Rate - Lines of Code (LOC)

Indicates the Lines of Code conversion percentage per file extension.

Formula

(script_success_lines / script_total_lines) * 100

Associated CSV Field names

  • Tables: ScriptTableLoCConversionRate

  • Views: ScriptViewLocConversionRate

  • Join Index: ScriptJoinIndexLoCConversionRate

  • Macros: ScriptMacroLoCConversionRate

  • Procedures: ScriptProcedureLoCConversionRate

  • Functions: ScriptFunctionLoCConversionRate

  • Triggers: ScriptTriggerLoCConversionRate

  • Indexes: N/A

Sample

IN -> Teradata_02.btq
-- Additional Params: -q SnowScript
CREATE SET TABLE Tables_Database.Employee
   (Associate_Id     INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);

CREATE SET TABLE Tables_Database.Employee2
   (Associate_Id     ANYTYPE!)
UNIQUE PRIMARY INDEX (Associate_Id);

Expected LOC Conversion Rate: 83.33%

Explanation: With the previous sample code we will have a 83.33% LOC Conversion Rate because line 5 of the input code (Associate_Id ANYTYPE!) could not be migrated and only 5 of the 6 total lines of code were migrated successfully.

You can refer to further information about this topic in the Conversion Rate Modes section of our documentation.

Total Object Quantity

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

CSV Associated Field Names

  • Tables: ScriptTableTotalOccurrences

  • Views: ScriptViewTotalOccurrences

  • Join Index: ScriptJoinIndexTotalOccurrences

  • Macros: ScriptMacroTotalOccurrences

  • Procedures: ScriptProcedureTotalOccurrences

  • Functions: ScriptFunctionTotalOccurrences

  • Triggers: ScriptTriggerTotalOccurrences

  • Indexes: ScriptIndexTotalOccurrences

Sample

IN -> Teradata_03.btq
-- Additional Params: -q SnowScript
-- Successfully parsed table.
CREATE SET TABLE Tables_Database.Employee
   (Associate_Id     INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);

-- Table with a parsing error that could not be identified.