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>'.

 

CALL (with anonymous procedure) | Snowflake Documentation

0
1 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.

0

Please sign in to leave a comment.