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.
Please sign in to leave a comment.
I created an issue based on your description https://youtrack.jetbrains.com/issue/DBE-9537