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

BTQ Input

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

Output

OUT -> Teradata_01.py

#*** Generated code is based on the SnowConvert Python Helpers version 2.0.6 ***
 
import os
import sys
import snowconvert.helpers
from snowconvert.helpers import Export
from snowconvert.helpers import exec
from snowconvert.helpers import BeginLoading
con = None
def main():
  snowconvert.helpers.configure_log()
  con = snowconvert.helpers.log_on()
  exec("""
    --** SSC-FDM-TD0024 - SET TABLE FUNCTIONALITY NOT SUPPORTED. TABLE MIGHT HAVE DUPLICATE ROWS **
    CREATE OR REPLACE TABLE Tables_Database.Employee (
      Associate_Id INTEGER,
      UNIQUE (Associate_Id)
    )
    """)
  #** SSC-EWI-0001 - UNRECOGNIZED TOKEN ON LINE '5' COLUMN '1' OF THE SOURCE CODE STARTING AT 'CRATE'. EXPECTED 'STATEMENT' GRAMMAR. LAST MATCHING TOKEN WAS 'CRATE' ON LINE '5' COLUMN '1'. CODE '81'. **
  #
  #--CRATE SET TABLE Tables_Database.Employee2
  #--   (Associate_Id     INTEGER)
  #--UNIQUE PRIMARY INDEX (Associate_Id)
   
  snowconvert.helpers.quit_application()

if __name__ == "__main__":
  main()

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

BTQ Input

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

Output

OUT -> Teradata_02.py

#*** Generated code is based on the SnowConvert Python Helpers version 2.0.6 ***
 
import os
import sys
import snowconvert.helpers
from snowconvert.helpers import Export
from snowconvert.helpers import exec
from snowconvert.helpers import BeginLoading
con = None
def main():
  snowconvert.helpers.configure_log()
  con = snowconvert.helpers.log_on()
  exec("""
    --** SSC-FDM-TD0024 - SET TABLE FUNCTIONALITY NOT SUPPORTED. TABLE MIGHT HAVE DUPLICATE ROWS **
    CREATE OR REPLACE TABLE Tables_Database.Employee (
      Associate_Id INTEGER,
      UNIQUE (Associate_Id)
    )
    """)
  exec("""
    --** SSC-FDM-TD0024 - SET TABLE FUNCTIONALITY NOT SUPPORTED. TABLE MIGHT HAVE DUPLICATE ROWS **
    CREATE OR REPLACE TABLE Tables_Database.Employee2 (
-- ** SSC-EWI-0001 - UNRECOGNIZED TOKEN ON LINE '6' COLUMN '5' OF THE SOURCE CODE STARTING AT 'Associate_Id'. EXPECTED 'Column Definition' GRAMMAR. LAST MATCHING TOKEN WAS 'ANYTYPE' ON LINE '6' COLUMN '22'. CODE '15'. **