cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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,

4 REPLIES 4
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.

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
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

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.

Top Solution Authors
Top Kudoed Authors