57P03 error when selecting Snowflake table

[ChrisRelt]

Hi, I have a connection using the native Qlik Sense Snowflake connector. I add data and browse my Snowflake schema in Qlik Sense, I select a view or table and the column names are returned but then I see the following error : "ERROR [57P03] No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command."

And I'm unable to Insert Script or continue.

Can anyone help me with - where do I set the 'use warehouse' command please ?

Thanks !

[gardenierbi]

You can define the warehouse in your connection string or ODBC connection!

[Senor_Dai]

Hi @ChrisRelt did you ever solve this? Im getting the same error...

many thanks

Dai

[NadiaB]

Hi @Senor_Dai 

By any chance did you provide a Warehouse in the connection details ?

The other option would be to do it programmatically if you are writing the query in the Script Editor to add "use warehouse" statement. The documentation can be found here: 

https://docs.snowflake.com/en/sql-reference/sql/use-warehouse.html

Hope it helps. 

[Senor_Dai]

Hi @NadiaB - thanks for the reply,  Yes - the warehouse is added to the configuration.  Ive also tried adding a system dsn on the server itself by installing the snowflake odbc driver - but that times out also.

[RenuLalwani]

if it doesn't work with System DSN too, its not a Qlik related issue. 

To me, It looks like the user doesn't have appropriate access to the warehouse. 

It could either be wrong assignment of warehouse to the user. OR you have not grand access to the Warehouse to the role

GRANT USAGE ON WAREHOUSE my_warehouse TO ROLE my_role;