How to use snowflake warehouse in dbt

Hi Team,
I am new to dbt. I am trying to execute the first example model provided by dbt but getting the following error message “000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the ‘use warehouse’ command.” My warehouse is up and running in the snowflake environment.

Could you pls help me to resolve this issue.

Regards
Ganesh

Hey Ganesh,

I am also new but I think I got my dbt-snowflake running properly.

You could check out my blog post draft and let me know whether it helps!

It’s actually still in draft status, but as you asked this question, I wanted to already share it with you and maybe improve it together. :slight_smile:

Bests
Robin

Hi Robin,

Thanks for your help. It got fixed by selecting the correct snowflake user role.

Once again appreciate your help.

Regards
Ganesh

Happy to hear that the problem got fixed! :slight_smile:

Did the article help or did you already fix it before?

Either way, would be happy for some critical feedback on the article!

Bests
Robin