MSCEWI3035

The table function is not supported when it is used as a collection of expressions.

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