MSCEWI3035
The table function is not supported when it is used as a collection of expressions.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
High
Description
TABLE function is not supported in Snowflake when it is used as a collection of expressions.
Example Code
Input Code:
SELECT
TABLE2.COLUMN_VALUES
FROM TABLE1 i, TABLE(i.groups) TABLE2;
Output Code:
/*** MSC-ERROR - MSCEWI3035 - TABLE FUNCTION IS NOT SUPPORTED WHEN IT IS USED AS A COLLECTION OF EXPRESSIONS ***/
SELECT
TABLE2.COLUMN_VALUES
FROM PUBLIC.TABLE1 i, TABLE(i.groups) TABLE2;
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated