MSCEWI1049

Not recognized function

Severity

Medium

Description

A function was not recognized by the conversion tool

Example code

Input Code:

REPLACE FUNCTION syslib.my_external_udf() // UDF declaration
...
...
SELECT syslib.my_external_udf(); // Qualified UDF
SELECT my_external_udf(); // UDF not qualified
SELECT NEWFUNCTION('param'); // Function the SnowConvert tool does not recognize yet

Output Code:

SELECT syslib.my_external_udf();

/*** MSC-ERROR - MSCEWI1049 - my_external_udf FUNCTION WAS NOT RECOGNIZED BY SNOWCONVERT ***/
SELECT my_external_udf();

/*** MSC-ERROR - MSCEWI1049 - NEWFUNCTION FUNCTION WAS NOT RECOGNIZED BY SNOWCONVERT ***/
SELECT NEWFUNCTION();

Recommendations

  • If the function is a Built-in specific function, ask for support so that the conversion tool recognizes and translates the function to a Snowflake equivalent. If the function is a UDF verify that the function is fully qualified when being called and that the function declaration is in a file in the input code being migrated.

  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated