CALL (with anonymous procedure) does not work in Snowflake
Answered
Whenever I try the following in Datagrip it doesn't work, but it does work in the browser of snowflake (snowsight i think) and it also works in Azure Data Factory:
WITH proc3 AS PROCEDURE ()
RETURNS VARCHAR
LANGUAGE javascript
AS
$$
var rs = snowflake.execute( { sqlText:
`SELECT 'value 1' AS "column 1" ;`
} );
return 'Done.';
$$
CALL proc3();
In Datagrip it returns:
[2024-09-06 09:42:11] syntax error line 10 at position 4 unexpected '<EOF>'.
Please sign in to leave a comment.
We do have a bug for it on YouTrack: https://youtrack.jetbrains.com/issue/DBE-20020/Snowflakes-temporary-anonymous-stored-procedures-throw-unexpected-EOF-error
Make sure to be logged in to YouTrack to see it.
We apologize for the inconvenience.