Error: Role Specified in the Connect String Does Not Exist or Not Authorized

Issue

My destination connection test fails with the following error:

Role '****' specified in the connect string does not exist or not authorized. Contact your local system administrator, or attempt to log in with another role, e.g. PUBLIC.

Environment

Destination: Snowflake

Resolution

To resolve this issue, ensure the following conditions are all true:

• The Fivetran user has a Manage Destination or Destination Creator user role. For more information, see our Role Permission Matrix Tables documentation.
• The role name is in upper case.
• The role name is not inside quotations. For more information, see our Snowflake prerequisites.

Cause

You specified an invalid Role name in the destination setup form.