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,

[Syndicate_Admin]

The issue is reported in the year 2020; However, I answer it so that there is a record of the solution that I have applied because it has also been presented to me.

It is worth mentioning that the OS used has been Windows 10.

I have solved the problem by downloading and installing each of the following components:

1. The (latest version) and, for this, the ww used has been: Visual C++ Redistributable for VS 2015
2. Driver for connecting to Snowflake using Open Database Connectivity (ODBC) and using SQL for accessing the data. Para ésto, se ha utilizado la siguiente www developers_snowflake._odbc

Once downloading the ODBC, you should run (as administrator) the Data Source Application (64-bit) and you have to do the following:

1. Check in the "Drivers" tab the SnowflakeDSIIDriver is displayed with its new version (in my case the ver. 2.25.11);
2. ADD a DNS System, choosing the Driver described in the previous point (SnowflakeDSIIDriver). This action causes the following popup to be deployed:
3. In it, you must provide certain relevant data such as:
   • Data Source: an ocn name that will identify this DNS System (the one you want. In my case, I have placed SF-);
   • User: The user you use to connect to the Snowflake (in my case I have placed datavard);
   • Password: Password you have (initially you can specify it only to verify that it really connects and then you must delete it for security);
   • Server: The URL without the http://. Specify it up to .com (In my case, I have placed aju-qxbxxxxxx.snowflakecomputing.com);
   • Database: the name of your database within SF (in my case, I have placed DATAVARD on it);
   • Schema: Specify your schema as it appears in SF (in my case, I have placed SAP on it);

Once all the previous parameters have been specified, and if you have specified the password, you can click on the Test button and, if everything is correct, you must display a popup informing the successful connection:

At this point, there is little left to make the successful connection in PBI. To do this, you must:

1. Choose the Get Data - More option:
2. Type ODBC (1) and then double-click ODBC (2) and click the CONNECT button;
3. A popup will be created in which you must select the name (1) created in the System DNS tab (in my case SF-) and, later, click on the OK button (2):
4. once you click on the OK button, you can see all the tables within the scheme and, additionally, successfully the content of one of them:

I hope you find it useful!

[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?