Snowflake database error no active warehouse on docs generate and tests

[dbt-labs]

Snowflake database error no active warehouse on docs generate and tests

[jtcohen6]

This is really weird!

000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command. is the error message I'd expect you to be seeing if you were trying to connect to a warehouse that doesn't exist, or to one that you don't have permission to access.

There's a subtle difference between the warehouse configured in profiles.yml (used by default for all connecting/querying), and the snowflake_warehouse config defined under models: in dbt_project.yml (used only for model materialization queries, to override the default, by calling use warehouse before and after).

I've been able to partially reproduce the error you're seeing, by configuring a nonexistent warehouse in my connection profile, and a real snowflake_warehouse for my models. dbt compile runs fine; dbt run runs mostly run (though I still encounter some errors); dbt test raises all sorts of errors, because tests don't inherit/use the snowflake_warehouse config today (#23); and same for dbt docs generate, which uses the profile (default) warehouse for its catalog queries.

Clearly, however, it sounds like you can access DEVELOPER_WH with your user's permissions (given the successful dbt run), and it's not like you're configuring different warehouses in your connection profile vs. model config.

Is there any chance that your permission to the DEVELOPER_WH is being granted/revoked by an automated process running elsewhere?

In the meantime, I'm going to transfer this issue to the dbt-snowflake repo. If we can get to the bottom of what's happening here, I imagine that's where we'll want to make the relevant code changes.

[warner-s]

Yes. Very weird indeed! Thanks for the rapid triage!

There are no automated processes granting or revoking access to the warehouse or roles. At one point I tested with a user which had simultaneous successful operations from a non-dbt agent.

I only added the snowflake_warehouse property as an attempt to force a warehouse for tests/docs after exhausting other options. I don't have a need or intention to include it if it's not required.

Thanks again and let me know if I can provide any additional info that would be helpful.

[warner-s]

The simple explanation prevails again: the warehouse name was not correct in the profile used. The fact that dbt run succeeded (presumably by using the default warehouse assigned to the user) clouded good judgment--hijacking fundamental troubleshooting discipline. Please accept my profuse apologies for the noise.