New function: MAP_KEYS may conflict with similarly named UDFs¶

Snowflake is introducing a new function named MAP_KEYS. If you have a UDF named MAP_KEYS, calls to your function have the following effect:

Before the change:

A call to your UDF named MAP_KEYS resolves to your UDF.

After the change:

A call to your UDF named MAP_KEYS resolves to the new built-in MAP_KEYS function, which fails with the following error:

Expand code block

Invalid argument types for function 'MAP_KEYS' ...

Show lessSee more

Scroll to top

The call to your UDF fails because the arguments passed to your UDF do not match the arguments expected by the built-in function.

To avoid having calls to your UDF resolve to the built-in function, you can either:

• Rename your UDF (using ALTER FUNCTION … RENAME TO …), and replace all references to the original UDF name with the new name.
• Fully qualify all references to your UDF by specifying the names of the database and schema containing the UDF. For example:
  Copy codeExpand code block

  SELECT my_database.my_schema.map_keys(...);

  Show lessSee more

  Scroll to top

Ref: 1430