Snowflake: The Warehouse that isn't really suspended.

[fitcja]

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,

[jorge-gt3]

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]

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]

@fitcja , refer these , if they can help

https://community.powerbi.com/t5/Issues/Snowflake-warehouse-is-not-suspended/idi-p/868075

https://community.snowflake.com/s/question/0D50Z000094ewm8/i-cant-connect-from-power-bi-i-get-the-er...

[fitcja]

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!!

[fitcja]

Any advice?