Failure in model stg_customers (models/stg_customers.sql)

Help
1

I am getting the below error in the dbt fundamental course itself. Plese share some input to fix my learning project

compiled code at target/run/jaffle_shop/models/stg_customers.sql

06:13:42

06:13:42

06:13:42 compiled code at target/compiled/jaffle_shop/models/stg_customers.sql

06:13:42

06:13:42

06:13:42 Failure in model stg_orders (models/stg_orders.sql)

06:13:42

06:13:42 Database Error in model stg_orders (models/stg_orders.sql)

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

compiled code at target/run/jaffle_shop/models/stg_orders.sql

06:13:42

06:13:42

06:13:42 compiled code at target/compiled/jaffle_shop/models/stg_orders.sql

06:13:42

06:13:42

06:13:42 Done. PASS=0 WARN=0 ERROR=2 SKIP=10 NO-OP=0 TOTAL=12

2

Hi @jtkarthikeyan,

In your profiles.yml file, have you configured this with all arguments? Particularly the warehouse: attribute. You’ll also need to be using a role: that has been access granted to that warehouse.

1 Like
3

Thanks @DataNath My issue resolved