Question

Why are Snowflake setup tests failing with the 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

Answer

• Make sure the following permissions are granted on the role
• Role name should be in UPPER CASE
• Should not have the role name in quotes as mentioned here