Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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;

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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;

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Confirmed this morning. This works.

Thank you!