topic 57P03 error when selecting Snowflake table in Connectivity & Data Prep

57P03 error when selecting Snowflake table

ChrisRelt — Wed, 22 Dec 2021 15:01:38 GMT

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 !

Re: 57P03 error when selecting Snowflake table

gardenierbi — Wed, 18 Aug 2021 10:29:49 GMT

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

Re: 57P03 error when selecting Snowflake table

Senor_Dai — Fri, 27 Jan 2023 16:57:46 GMT

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

many thanks

Dai

Re: 57P03 error when selecting Snowflake table

NadiaB — Tue, 31 Jan 2023 17:46:22 GMT

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.

Re: 57P03 error when selecting Snowflake table

Senor_Dai — Fri, 03 Feb 2023 15:35:06 GMT

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.

Re: 57P03 error when selecting Snowflake table

RenuLalwani — Tue, 07 Feb 2023 12:27:14 GMT

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;