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 ![]()
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.![]()