Snowflake Connection Issue(Get Rows)

[nraizada (Nitin Raizada)]

Hi,

We are trying to connect to snowflake via webMethods. However, when we try to run a query "Select count(1) from <

>. we are able to get the results. But when we try to run it as “Get Rows” then we get an error as
“No active warehouse selected in the current session. Select an active warehouse with the ‘use warehouse’ command.”

Can you please help in letting us know how do we set the Warehouse while trying to get rows from Snowflake?
Regards,
Nitin

[Venkata_Kasi_Viswanath_Mugada1 (Kasi Mugada)]

This appears to be an issue on Snowflake’s side (user privileges, mostly), from a Google search.

Example - Snowflake Community

Search online and see if any articles help you.

KM