Elements Report
The Elements report shows a summarized view of the grammar elements, along with their status and key context information
Last updated
The Elements report shows a summarized view of the grammar elements, along with their status and key context information
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
The term "element" is used in this context to address a grammar element; that is, an element from a grammar that has a name, a syntax and a purpose within a specific language.
Usually, these elements are highlighted and quite important within the documentation of a language.
These are some examples of elements in SQL languages:
Any DDL, such as CREATE TABLE
and CREATE VIEW
Important content of DML, such as PARTITION BY
and NOT NULL
Any DML, like INSERT
and DELETE
Some important expressions, such as IN
, NOT IN
, BETWEEN
and LIKE
Operators, including conditionals and arithmetic operators
Some internal parts of queries, such as ORDER BY
, WHEN
, INNER JOIN
and TOP
.
Important functions, such as AVG
and RANK
Essentially, anything that is worth keeping track of for assessment purposes can be considered an element.
The elements report can be found in a folder named "reports", in the output folder of your conversion. The name of the file itself starts with "Elements" so it can easily be located.
The format of the file is .CSV.
The elements report is presented in a table format, and contains the following columns:
SessionID
The session ID of the transformation. This is a unique identifier for the transformation session.
Category
The element's corresponding category. These can be DDL, DDL Content, DML, Functions & Expressions, Statement, Query, and so on.
Grammar Element
The name associated to the element, often the same as found in the official documentation for the language.
File Type
The type of the file that contains the element. For example: SQL.
Total Count
The total count of that particular element found during the transformation process.
Not Converted Count (Self)
The count of that particular element that presented issues severe enough for it to not properly transform. Usually unsupported structures or elements that had a particular transformation error. Keep in mind that "Self" means that some of the inner contents of the element may or may not be not converted, but if the element itself did not present errors, it will not be counted towards this column.
Each individual element is summarized using a specific criteria, that may include multiple columns to form a "composite key". The basic grouping is made using the Category, Grammar Element and File Type columns.
Following this convention, the same SELECT
element could be summarized differently depending on the type of the file that contains it, or two elements that share the same grammar element (or name) may still be summarized independently if their category is different.