Snowflake query history shows the queries across threads sharing same session. Any suggestions to restrict this behavior to ensure thread specific query execution or separate session creation for each thread?
Snowflake driver version :
net.snowflake
snowflake-jdbc
3.13.7
I have following grants in snowflake
role1 has access to only warehouse1
role2 has access to only warehouse2
In Spring Boot API, I am calling queries sequentially as mentioned below.
use role ${xyz};
use warehouse ${abc};
when I am hitting API sequentially even though each thread sharing same session id, queries are executing in sequential order, but when the multiple concurrent requests given to API query mix happening, hence throwing authorization error
use role role1 ;
use role role2;
use role warehouse1;
