SSC-EWI-SY0004
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:
SELECT
*
FROM
MyProcedure(TABLE (SELECT * FROM TABLE1));
Output Code:
SELECT
*
FROM
TABLE(MyProcedure(
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0004 - UNSUPPORTED SYNTAX TABLE FUNCTION CAN'T RECEIVE A QUERY AS PARAMETER ***/!!!
TABLE(SELECT * FROM TABLE1)));
Recommendations
If you need more support, you can email us at [email protected]
Last updated