SnowConvert AI - Functions Usage Report¶

What is an “function usage”?¶

The term “usage” is used in this context to indicate that a specific function was invoked in the code. This function could be a built-in or user-defined function in a source language.

These are some examples of places where functions can be invoked in SQL languages:

  • Any DDL, CREATE TABLE default columns value or as part of a CREATE VIEW select using a function.

  • Any DML, like INSERT and DELETE

  • In procedural language, assign the returned value of a function to a sql variable

  • In the FROM using table valued functions.

Where can I find it?¶

The Functions Usage report can be found in a folder named “reports”, in the output folder of your conversion. The name of the file itself starts with “SqlFunctionsUsage” so it can easily be located.

The format of the file is .CSV.

What information does it contain?¶

The function usage report is presented in a table format, and contains the following columns:

ColumnDescription
FunctionThe name of the function found in code, or its signature in the case of a UDF.
CountThe function's usage summarized count by migration status.
CategoryThe function category. These can be User_Defined, Built_In, or Uncategorized.
Migration StatusThe migration status of the function invocation. These can be Pending (not transformed to Snowflake), PendingSPCall (requires manual intervention because it was converted to a stored procedure), and Transformation (successfully converted to Snowflake).

Summarization¶

Each individual function usage is summarized using a specific criteria, that may include multiple columns to form a “composite key”. The basic grouping is made using the Category, and Migration Status columns.

Language: English