SSC-EWI-OR0035

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

Some parts in the output code are omitted for clarity reasons.

Severity

Medium

Description

TABLE function is not supported in Snowflake when it is used as a collection of expressions.

Example Code

Input Code:

IN -> Oracle_01.sql

SELECT 
TABLE2.COLUMN_VALUES
FROM TABLE1 i, TABLE(i.groups) TABLE2;

Output Code:

OUT -> Oracle_01.sql

// SnowConvert Helpers Code section is omitted.
SELECT
TABLE2.COLUMN_VALUES
FROM
TABLE1 i,
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0035 - TABLE FUNCTION IS NOT SUPPORTED WHEN IT IS USED AS A COLLECTION OF EXPRESSIONS ***/!!! TABLE(i.groups) TABLE2;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [e-mail]