Top-Level Queries Report

The top-level queries report provides a general overview of the main queries (SELECT, UPDATE, INSERT, DELETE) present in your source code that are not part of other queries.

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

What is a "Top-Level Query"?

Top-level query is the term used to refer to the following SQL structures that are located at the top-level of your source code, meaning they are not part of another query:

Structure	Assessment for Teradata SQL *	Assessment for Oracle SQL	Assessment for Transact SQL
Select	🗸	🗸	🗸
Update	🗸	🗸	🗸
Insert	🗸	🗸	🗸
Delete	🗸	🗸	🗸
Merge	-	🗸	🗸

*Teradata currently uses a different report generation mechanism. It's planned to use the same one that Oracle and Transact use. For this reason, more accurate information for Teradata reports can be found here.

Where can I find it?

The top-level queries report can be found in a folder named "reports", in the output folder of your conversion.

The name of the file itself starts with "TopLevelQueries" so it can easily be located.

The format of the file is .CSV.

What information does it contain?

The top-level queries report contains the following information about all the top-level queries found while converting:

Column	Description
PartitionKey	The unique identifier of the conversion.
FileType	The type of file that the object is in. (SQL, BTEQ, etc...)
ObjectName	The top-level statement index within the file or, a custom name for the query, if specified in a comment above it with the following format: /* CustomName </sc-dml>*/
HighLevelObject	The friendly name of the top-level query.
FileName	The name of the file in which the query is located. Uses the relative path starting from the input directory.
LineNumber	The line number inside the file where the query is located.
LinesOfCode	The total lines of code that the query has.
HighestEWISeverity	The highest EWI severity found within the query.
ConvertsionStatus	The conversion result for the query, possible values are: Success, Partial, NotSupported and Failed.
EWIs	The descriptions of all the EWIs found within the query.
UDFsUsed	The names of all the user-defined functions found within the query.
ConversionPercentage	The percentage of the query that was successfully converted.
EWIsNumber	The amount of EWIs found within the query.
ObjectDB	The name of the database or schema that this object belongs to. This may vary between languages. Please check here the possible outputs.
CharacterCount	The number of characters that form the query
CharacterConversionPercentage	The percentage of characters that were successfully converted.
LoCConversionPercentage	Planned.