cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fitcja
Helper I
Helper I

Snowflake: The Warehouse that isn't really suspended.

When trying to query into Snowflake I get an error that says, " The warehouse <WAREHOUSE_NAME>  is suspended. You will need to resume it before importing data." However, the warehouse is most definitely not suspended. I saw somewhere that this might have to do with Roles but couldn't find the details on how to either fix the issue or work around it using OData. Does anyone know how to accomplish either?

 

Side note, I'm trying to import the data,

5 REPLIES 5
jorge-gt3
New Member

I had the exact same issue and everything started working after installing both ODBCs listed on this page:

https://docs.snowflake.com/en/user-guide/odbc-windows.html

 

At first I installed only the 64bit one, but it didnt work, so I tried the 32bit one and everything started working after restarting PowerBI.

Icey
Community Support
Community Support

Hi @fitcja ,

 

Do you have warehouse operation permissions? If don't, please contact the administrator and grant access.

 

Reference: 

I can't connect from Power bI - I get the error that the warehouses is suspended;

Access Control Privileges;
Configuring Access Control.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

amitchandak
Super User IV
Super User IV

I really appreciate the quick response, but while both of those posts mentions the issue, neither provides anything beyond, "Maybe the warehouse is suspended..." or "Maybe you're using the wrong password..." Neither of those things are at issue.

 

Rather, I suspect that the problem is rooted in that I have to choose a Role while in Snowflake and somehow that gums things up when trying to get access to the table within the warehouse from Power BI. 

 

I've seen some references that the Snowflake connector isn't fully baked yet and that some people have figured out how to use the OData connector as a work around - but I haven't seen any detailed instructions.

 

So, if someone can provide some advice that gets into the meat of this or has definitively established that Power BI and Snowflake can't connect on a robust level yet in the way, say, Tableau can, I would really appreciate it.

 

Thanks!!

Any advice?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.