Object Conversion Summary

This section shows the object conversion Summary

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

The Object Conversion Summary section of the assessment report for Sql

Identified Objects

The count of all the top-level DDL objects (Table, View, Procedure, etc.) that the SnowConvert identified. If there were a parsing error on an object that made it unreconcilable, it wouldn't be an identified object.

CSV Associated field name

• TotalIdentifiedObjects

Sample

Input

-- Statement without parsing error
CREATE TABLE table1(
     column1 INT,
     column2 INT 
);

-- Statements with parsing error
CREATE TABLE table2(
     column1 INT,
     column2 INT INT
);

CRATE TABLE table3(
     column1 INT
);

Output

-- Statement without parsing error
CREATE TABLE table1(
     column1 INT,
     column2 INT
);

-- Statements with parsing error
CREATE TABLE table2(
     column1 INT
-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 14 OF THE SOURCE CODE. **
--     column2 INT INT
);

-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 8 OF THE SOURCE CODE. **
--CRATE TABLE table3(
--     column1 INT
--)
 ;

Expected Identified Objects: 2

Explanation: The table1 presented doesn't have a parsing error; the table2 even though it has a parsing error, the parser is still capable of recognizing the object as a table, so both are counted as an identified object; the table3 has a parsing error that makes it unreconcilable for the parser and, as a consequence, is not counted as an identified object.

Object Conversion Rate

The percentage of fully converted objects among the objects identified

Formula

(identify_objects_converted_succesfully / total_identify_objects) * 100

CSV Associated field name

• ObjectConversionRate

Sample

Input

CREATE TABLE table1(
     column1 INT,
     column2 INT 
);

CREATE VIEW view1 AS
SELECT orderkey
FROM orders;

CREATE TABLE table2(
     COLNAME VARCHAR(20)
)
ON COMMIT PRESERVE ROWS;

Output

CREATE OR REPLACE TABLE table1 (
     column1 INT,
     column2 INT
);

--** MSC-WARNING - MSCEWI1050 - MISSING DEPENDENT OBJECT "orders" **
CREATE OR REPLACE VIEW view1
AS
SELECT orderkey
FROM
orders;

CREATE OR REPLACE TABLE table2 (
     COLNAME VARCHAR(20)
);
-- ** MSC-ERROR - MSCEWI1093 - ON COMMIT NOT SUPPORTED **
--                                           ON COMMIT PRESERVE ROWS

Expected Object Conversion Rate: 66.66%

Explanation: In this example we have 3 statements, all of them have been identified as an object, but just the table1, and the view1 have a 100% conversion rate. The table3 has an error warning meaning that the conversion of this table is not 100%, that's why just 2 of the 3 statements are counted as fully converted objects.

Fully Converted Objects

The number of identify objects that were converted successfully, meaning this objects have a 100% conversion rate.

CSV Associated field name

• ObjectsSuccessfullyConverted

Sample

Input

CREATE TABLE table1(
     column1 INT,
     column2 INT 
);

CREATE VIEW view1 AS
SELECT orderkey
FROM orders;

CREATE TABLE table2(
     COLNAME VARCHAR(20)
)
ON COMMIT PRESERVE ROWS;

Output

CREATE OR REPLACE TABLE table1 (
     column1 INT,
     column2 INT
);

--** MSC-WARNING - MSCEWI1050 - MISSING DEPENDENT OBJECT "orders" **
CREATE OR REPLACE VIEW view1
AS
SELECT orderkey
FROM
orders;

CREATE OR REPLACE TABLE table2 (
     COLNAME VARCHAR(20)
);
-- ** MSC-ERROR - MSCEWI1093 - ON COMMIT NOT SUPPORTED **
--                                           ON COMMIT PRESERVE ROWS

Expected Fully Converted Objects: 2

Explanation: In this example we have 3 statements, all of them have been identified as an object, but just the table1, and the view1 have a 100% conversion rate. The table3 has an error warning meaning that the conversion of this table is not 100%, that's why just 2 of the 3 statements are counted as fully converted objects.

Unrecognized Elements

Represents any code element (or parts of them) such as DML, DDL, control statements, with parsing errors that SnowConvert was unable to process.

CSV Associated field name

• UnrecognizedElements

Sample

Input

CREATE TABLE table1(
     column1 INT,
     column2 INT 
);

CREATE VIEWW view1 AS
SELECT orderkey
FROM orders;

Output

CREATE OR REPLACE TABLE table1 (
          column1 INT,
          column2 INT
     );

-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 6 OF THE SOURCE CODE. **
--CREATE VIEWW view1 AS
--SELECT orderkey
--FROM orders

Expected Unrecognized Elements: 1

Explanation: In this example we have 2 statements, the table1 is successfully identified as an object, in the other hand the view1, has a parsing error that means it's impossible to identify the view as an object, because of this SnowConvert reports 1 Unrecognized object.

Lines of Code in Unrecognized Elements

Represents the number of lines in unrecognized elements.

CSV Associated field name

• UnrecognizedElementsLOC

Sample

Input

CREATE TABLE table1(
     column1 INT,
     column2 INT 
);

CREATE VIEWW view1 AS
SELECT orderkey
FROM orders;

Output

CREATE OR REPLACE TABLE table1 (
          column1 INT,
          column2 INT
     );

-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 6 OF THE SOURCE CODE. **
--CREATE VIEWW view1 AS
--SELECT orderkey
--FROM orders

Expected Lines of Code in Unrecognized Elements: 3

Explanation: The element view1 is an unrecognized element, this means that the lines related to this elements are counted as Lines of Code in Unrecognized Elements.

Wrapped Objetcs

Represent the number of wrapped objects present in source input code

This field applies only to Oracle reports.

CSV Associated field name

• WrappedObjects

Sample

Input

CREATE OR REPLACE PROCEDURE PROC123 wrapped 
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
7
5f 9a
s25TmlGXjM9M+sFyW30UiYolBNowg6Rff8upynSmTEOUpAF/NYAbDvDIFsjmTDq1lhTLv74p
xZxnFllpF1iGaIfGOejm9divodC9qOeCQyIa89b2l+uNwqOzJHmOKVySIoi/l9IooFyJs9Es
FQyI4Q==

/

Output

----** MSC-ERROR - MSCEWI3055 - TRANSFORMATION FOR WRAPPED PROCEDURE IS NOT SUPPORTED **
--CREATE OR REPLACE PROCEDURE PROC123 wrapped
--a000000
--b2
--abcd
--abcd
--abcd
--abcd
--abcd
--abcd
--7
--5f 9a
--s25TmlGXjM9M+sFyW30UiYolBNowg6Rff8upynSmTEOUpAF/NYAbDvDIFsjmTDq1lhTLv74p
--xZxnFllpF1iGaIfGOejm9divodC9qOeCQyIa89b2l+uNwqOzJHmOKVySIoi/l9IooFyJs9Es
--FQyI4Q==
;

Expected Lines of Code in Unrecognized Elements: 1

Explanation: The procedure is declared as a wrapped object, that's why is counted as a wrapped object.