https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
d

delightful-city-54850

07/06/2023, 12:27 PM
This message contains interactive elements.
This message contains interactive elements.
b

billions-xylophone-11752

07/06/2023, 5:38 PM
Hey, @delightful-city-54850 - sorry to hear you're having trouble! Can you click "Edit Connection Info" and confirm the
Warehouse
on the form is correct? I'm trying to get my env into the same error, and so far, that's the only way I've been able to recreate that error message.
Looking into it more, it could also be an issue with the role you created not having appropriate access to the warehouse.
d

delightful-city-54850

07/07/2023, 4:24 PM
Hi Michael! You’re right — snowflake permissioning is fun 🙂 Basically, I created a user/role and assigned a default warehouse (but didn’t grant usage on the warehouse to the role). I used these two commands to fix it:
GRANT USAGE ON WAREHOUSE [warehouse_name] TO ROLE [role_name];
ALTER USER [user_name] SET DEFAULT_WAREHOUSE =  [warehouse_name];
Thanks again for the suggestion!
b

billions-xylophone-11752

07/07/2023, 4:27 PM
I'm so glad to hear!
11 Views