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.bteq
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.bteq
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);