0

I'm getting the following error when doing a 'dbt run'

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

My profile has the following entry: role: transform_role schema: dbt threads: 1 type: snowflake user: transform_user warehouse: transform_wh

I have also run the following in snowflake to set the user's default warehouse to transform_wh: alter user transform_user set DEFAULT_WAREHOUSE = 'TRANSFORM_WH';

But I'm still getting the following error when doing 'dbt run':

05:24:41 Database Error in model my_first_dbt_model (models\example\my_first_dbt_model.sql)
05:24:41 000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command. 05:24:41 05:24:41 compiled SQL at target\run\learn_dbt\models\example\my_first_dbt_model.sql 05:24:41

I have seen similar questions but they don't seem to resolve my issues. I would appreciate any insight and/or help. Thanks.

koolraul
  • 1
  • 1

1 Answers1

0

It's hard to know without more information, but the most likely cause is that your user's role doesn't have permissions to use the warehouse.

Josh D.
  • 1,068
  • 9
  • 18
  • I finally figured out how to assign permission on a warehouse to a role. All things are resolved now. Thanks. – koolraul Apr 20 '22 at 20:28