Links

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 11mo ago