Datagrip Snowflake Connection: Fetching last query

Hi,

i have a problem fetching old query results on snowflake with data grip (query works on dbeaver and webgui)

Example:

SELECT $1 AS value FROM VALUES (1), (2), (3);

SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1))) WHERE value > 1;

Result of the 2nd query should be (2,3).

But i get a result of two columns named A and B including the values (<<useddb>>, <<user>>).

Any idea why i can't fetch the result of the last query in datagrip?

I am using snowflake v3.7 jdbc connector on dbeaver and datagrip.

Best regards.

 

 

 

1 comment

Please sign in to leave a comment.