SnowConvert AI - Scripts - Identified Objects¶
Bemerkung
Diese Seite der Dokumentation gilt nur für Teradata.
Die Aufschlüsselung aller Datenbankobjekte, die in allen Skriptdateien erstellt oder geändert wurden (BTEQ, BTQ, FL, ML, TPUMP, TPT).
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_scripts_objects / total_scripts_objects) * 100
Zu CSV zugeordnete Feldnamen¶
Tables: ScriptTableObjectConversionRate
Views: ScriptViewObjectConversionRate
Join Index: ScriptJoinIndexObjectConversionRate
Macro: ScriptMacroObjectConversionRate
Procedures: ScriptProcedureObjectConversionRate
Functions: ScriptFunctionObjectConversionRate
Triggers: ScriptTriggerObjectConversionRate
Indizes: N/A
Beispiel¶
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);
#*** Generated code is based on the SnowConvert AI 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()
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 - LOC¶
Zeigt den prozentualen Anteil der Konvertierung von Codezeilen pro Dateierweiterung an.
Formel¶
(script_success_lines / script_total_lines) * 100
Zugehörige CSV-Feldnamen¶
Tables: ScriptTableLoCConversionRate
Views: ScriptViewLocConversionRate
Join Index: ScriptJoinIndexLoCConversionRate
Macros: ScriptMacroLoCConversionRate
Procedures: ScriptProcedureLoCConversionRate
Functions: ScriptFunctionLoCConversionRate
Triggers: ScriptTriggerLoCConversionRate
Indizes: N/A
Beispiel¶
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);
#*** Generated code is based on the SnowConvert AI 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'. **
-- Associate_Id ANYTYPE!,
UNIQUE (Associate_Id)
)
""")
snowconvert.helpers.quit_application()
if __name__ == "__main__":
main()
Erwartete LOC-Konvertierungsrate: 83,33 %
Erläuterung: Mit dem vorherigen Beispielcode haben wir eine Konvertierungsrate von 83,33 % Codezeilen (LOC) weil Zeile 5 des Eingabecodes (Associate_Id ANYTYPE!)
nicht migriert werden konnte und nur 5 der insgesamt 6 Codezeilen erfolgreich migriert wurden.
Bemerkung
Weitere Informationen zu diesem Thema finden Sie im Abschnitt Modi der Konvertierungsrate in unserer Dokumentation.
Total Object Quantity¶
Represents the total amount of objects identified by SnowConvert AI during the parsing phase.
Zu CSV zugeordnete Feldnamen¶
Tables: ScriptTableTotalOccurrences
Views: ScriptViewTotalOccurrences
Join Index: ScriptJoinIndexTotalOccurrences
Macros: ScriptMacroTotalOccurrences
Procedures: ScriptProcedureTotalOccurrences
Functions: ScriptFunctionTotalOccurrences
Triggers: ScriptTriggerTotalOccurrences
Indexes: ScriptIndexTotalOccurrences
Beispiel¶
-- 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.
CRATE SET TABLE Tables_Database.Employee2
(Associate_Id INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);
#*** Generated code is based on the SnowConvert AI 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()
# Successfully parsed table.
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 '7' COLUMN '1' OF THE SOURCE CODE STARTING AT 'CRATE'. EXPECTED 'STATEMENT' GRAMMAR. LAST MATCHING TOKEN WAS 'CRATE' ON LINE '7' COLUMN '1'. CODE '81'. **
#
#---- Table with a parsing error that could not be identified.
#--CRATE SET TABLE Tables_Database.Employee2
#-- (Associate_Id INTEGER)
#--UNIQUE PRIMARY INDEX (Associate_Id)
snowconvert.helpers.quit_application()
if __name__ == "__main__":
main()
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.
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 für diese Spalte die Codezeilen des Objekts der obersten Ebene sowie die Kommentare verwendet werden. Leere Zeilen hingegen werden in dieser Spalte nicht gezählt.
Zu CSV zugeordnete Feldnamen¶
Tables: ScriptTableTotalLinesOfCode
Views: ScriptViewTotalLinesOfCode
Join Index: ScriptJoinIndexTotalLinesOfCode
Macros: ScriptMacroTotalLinesOfCode
Procedures: ScriptProcedureTotalLinesOfCode
Functions: ScriptFunctionTotalLinesOfCode
Triggers: ScriptTriggerTotalLinesOfCode
Indexes: ScriptIndexTotalLinesOfCode
Beispiel¶
-- Hello World
CREATE SET TABLE Tables_Database.Employee
(Associate_Id INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);
CREATE SET TABLE Tables_Database.Employee2
(-- hello world
Associate_Id ANYTYPE!)
UNIQUE PRIMARY INDEX (Associate_Id);
#*** Generated code is based on the SnowConvert AI 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()
# Hello World
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)
)
""")
# hello world
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 '8' COLUMN '4' OF THE SOURCE CODE STARTING AT 'Associate_Id'. EXPECTED 'Column Definition' GRAMMAR. LAST MATCHING TOKEN WAS 'ANYTYPE' ON LINE '8' COLUMN '21'. CODE '15'. **
-- Associate_Id ANYTYPE!,
UNIQUE (Associate_Id)
)
""")
snowconvert.helpers.quit_application()
if __name__ == "__main__":
main()
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.
Parsing Errors¶
Stellt die Anzahl der Parsing-Fehler dar, die sich innerhalb der identifizierten Objekte befinden.
Zu CSV zugeordnete Feldnamen¶
Tables: ScriptTableTotalParsingErrors
Views: ScriptViewTotalParsingErrors
Join Index: ScriptJoinIndexTotalParsingErrors
Macros: ScriptMacroTotalLinesOfCode
Procedures: ScriptProcedureTotalParsingErrors
Functions: ScriptFunctionTotalParsingErrors
Triggers: ScriptTriggerTotalParsingErrors
Indexes: ScriptIndexTotalParsingErrors
Beispiel¶
-- 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.
CRATE SET TABLE Tables_Database.Employee2
(Associate_Id INTEGER)
UNIQUE PRIMARY INDEX (Associate_Id);
#*** Generated code is based on the SnowConvert AI 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()
# Successfully parsed table.
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 '7' COLUMN '1' OF THE SOURCE CODE STARTING AT 'CRATE'. EXPECTED 'STATEMENT' GRAMMAR. LAST MATCHING TOKEN WAS 'CRATE' ON LINE '7' COLUMN '1'. CODE '81'. **
#
#---- Table with a parsing error that could not be identified.
#--CRATE SET TABLE Tables_Database.Employee2
#-- (Associate_Id INTEGER)
#--UNIQUE PRIMARY INDEX (Associate_Id)
snowconvert.helpers.quit_application()
if __name__ == "__main__":
main()
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.