SnowflakeDocumentation Home

MSCEWI5016

UNNEST FUNCTION IS NOT SUPPORTED

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

High

Description

The use of Unnest Function is not supported in Snowflake

Example Code

Input Code: 

SELECT * FROM
UNNEST(arrray) WITH ORDINALITY

Output Code:

SELECT * FROM
/*** MSC-ERROR - MSCEWI1021 - UNNEST NOT SUPPORTED ***/
UNNEST(arrray) WITH ORDINALITY

Recommendations

  • If this error happens is because there is no Snowflake equivalent for the node that is being converted.

  • If you need more support, you can email us at [email protected]

PreviousMSCEWI5015NextMSCEWI5017

Last updated