Unsupported Syntax Table function can't receive a query as a parameter.
Severity
High
Description
Snowflake does not support passing RESULTSET as parameter in a table-value function call.
Code Examples
Input Code:
IN -> Sybase_01.sql
SELECT
*
FROM
MyProcedure(TABLE (SELECT * FROM TABLE1));
Output Code:
OUT -> Sybase_01.sql
SELECT
*
FROM
TABLE(MyProcedure(
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0004 - UNSUPPORTED SYNTAX TABLE FUNCTION CAN'T RECEIVE A QUERY AS PARAMETER ***/!!!
TABLE(SELECT * FROM TABLE1)));
