# No active warehouse selected in the current session. User has write permissions on the schema and to use the warehouse

**URL:** https://discourse.getdbt.com/t/no-active-warehouse-selected-in-the-current-session-user-has-write-permissions-on-the-schema-and-to-use-the-warehouse/11468
**Category:** Help
**Tags:** snowflake, git, dbt-core
**Created:** [January 9, 2024, 2:00pm UTC](https://discourse.getdbt.com/t/no-active-warehouse-selected-in-the-current-session-user-has-write-permissions-on-the-schema-and-to-use-the-warehouse/11468 "2024-01-09T14:00:39Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![asghari.pz](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/asghari.pz/32/3499_2.png) [@asghari.pz](https://discourse.getdbt.com/u/asghari.pz)
#### Post date: [January 9, 2024, 2:00pm UTC](https://discourse.getdbt.com/t/no-active-warehouse-selected-in-the-current-session-user-has-write-permissions-on-the-schema-and-to-use-the-warehouse/11468/1 "2024-01-09T14:00:39Z")

</div>

I am running a workflow on Github actions with which runs the dbt build command on snowflake.  
The user in my profile.yaml file is the owner of the schema in the database which it interacts with and has ‘usage’ permission on the database itself. It also has the permission to the warehouse and it is set as its default warehouse on snowflake. However I keep receiving this error when the workflow runs:

000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the ‘use warehouse’ command.

---

<div class="post-metadata">

### Author: ![mantesh](https://avatars.discourse-cdn.com/v4/letter/m/e9bcb4/32.png) [@mantesh](https://discourse.getdbt.com/u/mantesh)
#### Post date: [August 25, 2026, 8:01am UTC](https://discourse.getdbt.com/t/no-active-warehouse-selected-in-the-current-session-user-has-write-permissions-on-the-schema-and-to-use-the-warehouse/11468/2 "2026-08-25T08:01:56Z")

</div>

solution 🙂

IN snowflake the default warehouse is COMPUTE\_WH and whenever you try to run dbt run in dbt studio then connection api reaches snowflake with ‘your\_warehouse\_name’ not ‘COMPUTE\_WH’ because of that that it refuses connection because condition is ‘your\_warehouse\_name’==‘default warehouse’ to get connected successfully to snowflake. So to solve this issue ,

Step: 1 go to snowflake and run this command

ALTER USER ‘your\_snowflake\_account\_name’ SET DEFAULT\_WAREHOUSE = ‘your\_warehouse’;

step:2 cross check your warehouse name by editing your DEV envirinment it should be same as your above set warehouse

step:3 refresh your dbt window and click on studio and try once again dbt run you will see run completed successfully.🙂