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

Help
, ,
1

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.

2

solution :slight_smile:

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.:slightly_smiling_face: