nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OAC "No active warehouse selected in the current session" error with Snowflake RPD Data Model

Dennis Paredes

Hi everyone,

I'm repeatedly hitting the following Snowflake error in Oracle Analytics Cloud (OAC/OAS) when working with an RPD-based Data Model connected to Snowflake:

"No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command."

The connection tests successfully and I can browse databases/schemas in the RPD, but any attempt to run a query or open an analysis fails with the above error.

What I’ve already tried the following (none worked):

1.Explicitly added the warehouse in the JDBC connection string:

jdbc:snowflake://xxxxxxx.us-east-1.snowflakecomputing.com/?warehouse=MY_WAREHOUSE

2. Added the following statement in both "Execute on Connect" and "Execute Before Query" sections of the connection pool:text

BEGIN  
USE WAREHOUSE MY_WAREHOUSE;
END;

3. Set the default warehouse on the Snowflake service account used by OAC:

ALTER USER OAC_SERVICE_USER SET DEFAULT_WAREHOUSE = 'MY_WAREHOUSE;

Has anyone successfully resolved this specific combination of OAC + RPD Data Model + Snowflake? It feels like the warehouse parameter isn’t being picked up when OAC initializes the session from the connection pool.

Any tips, known workarounds, or patches would be greatly appreciated!

Find more posts tagged with

OAC

rpd

Accepted answers

Steve F-2

Hi @Dennis Paredes

Welcome to the Oracle Analytics Community!, and thank you for your question.

The error/message is coming from Snowflake, not from OAC/OAS.

It may be a privilege issue for the connecting user.

Try the solution here:

https://stackoverflow.com/questions/60265744/query-to-snowflake-database-isnt-working-because-no-active-warehouse-is-selecte#63218159

Any SELECT operation would require a virtual warehouse (compute) to run. That's the part Snowflake will charge you for, so if you don't have the USAGE permission on a virtual warehouse, you can't run any queries.

GRANT USAGE ON WAREHOUSE my_warehouse TO ROLE writer_role;

Where the connecting user is a member of the role, or I suppose you may be able to grant directly to the connecting user.

I am sure other Snowflake users could comment.

All comments

RVohra

Hope we get some response from the Oracle SME, in the meantime you may want to open a ticket with Oracle Support.

Steve F-2

Any SELECT operation would require a virtual warehouse (compute) to run. That's the part Snowflake will charge you for, so if you don't have the USAGE permission on a virtual warehouse, you can't run any queries.

GRANT USAGE ON WAREHOUSE my_warehouse TO ROLE writer_role;

Where the connecting user is a member of the role, or I suppose you may be able to grant directly to the connecting user.

I am sure other Snowflake users could comment.

RVohra

Thanks SteveF for looking into it, appreciate it!

Dennis Paredes

Thank you, @Doug Ross . GRANT USAGE resolved the issue