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

when you have put all credentials and account details and also warehouse name right in dbt dev environment BUT then slao you get same Error ?why?

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: