New function: ARRAY_FLATTEN may conflict with similarly named UDFs¶

In the current Snowflake release, Snowflake has introduced a new built-in function named ARRAY_FLATTEN.

ARRAY_FLATTEN flattens an ARRAY of ARRAYs into a single ARRAY.

• If the ARRAY is nested more than two levels deep, then only a single level of nesting is removed.
• If the input ARRAY is NULL or contains any NULL elements, then the result is NULL.

If you have a UDF named ARRAY_FLATTEN, this behavior change has the following effect:

Previously:

Calls to ARRAY_FLATTEN resolve to your UDF.

Currently:

Calls to ARRAY_FLATTEN will resolve to the new built-in ARRAY_FLATTEN function.

The built-in ARRAY_FLATTEN function might work differently than your UDF.

If the documented semantics of the new built-in ARRAY_FLATTEN function does not match the semantics of your UDF, 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.array_flatten(...);

  Show lessSee more

  Scroll to top

Ref: 1239