search

Snowflake-Labs / Excelerator

This is an Excel Addin for Windows that reads and writes data to Snowflake
Apache License 2.0
78 stars 22 forks source link

Cannot change the role #23

Closed howardnguyen1211 closed 3 years ago

howardnguyen1211 commented 3 years ago

the default role does not have any warehouse attached to it. want to change the default role, but it popped up the warehouse list which is empty.

howardnguyen1211 commented 3 years ago

I fixed the problem.

ssegal100 commented 3 years ago

@howardnguyen1211 What did you do to resolve the issue?

howardnguyen1211 commented 3 years ago

change the default wh use cmd below, then replace the old add-ins file with the new one from git. since the old one had cached with the old role.

ALTER USER user SET DEFAULT_WAREHOUSE = 'new wh';

ssegal100 commented 3 years ago

@howardnguyen1211 Thanks. If this happens in the future, or if you need to change the role that is being used for login, you can right click on the tabs at the bottom of the worksheet and select Unhide: image

Select the SnowflakeConfig worksheet. On this worksheet you can now change the Role that is used to login. image

You probably want to hide that workbook when done.

howardnguyen1211 commented 3 years ago

Nice! Thanks for letting me know that.