Issue
Snowflake setup tests are failing with the following error:
Default Warehouse Test: User's configured default role 'role_name' does not exist or not authorized. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another.
Environment
Destination: Snowflake
Resolution
To resolve the error, please check to confirm that the following are all true:
- The following permissions are granted on the role.
- The name is in upper case.
- The role name is not in quotations (as mentioned here).