Forum Discussion
Snowflake Connector Bug - Role
The snowflake connector only works when I use my default role in the "Specify a text value to use as Role name" option. If I use a role that is not my default role (set in snowflake) it does not allo...
Hey I fixed this in my account - in Snowflake within the Security Integration you need to enable EXTERNAL_OAUTH_ANY_ROLE_MODE.
ALTER SECURITY INTEGRATION {} SET EXTERNAL_OAUTH_ANY_ROLE_MODE = ENABLE;
We have also seen this as a problem. After creating the security integration we are able to create the connection but we are only able to connect with the default role. Using another role gives an authentication error.