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.
Last updated
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.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
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 .
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.
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
CharacterCount
The number of characters that form the query
CharacterConversionPercentage
The percentage of characters that were successfully converted.
LoCConversionPercentage
Planned.
The name of the database or schema that this object belongs to. This may vary between languages.