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

This bug is still present.

 

If I set my default role to PUBLIC, I can log into Power BI using AAD either leaving the 'Specify a text value to use as Role name (optional)' empty, or entering the value PUBLIC. If I enter any other value, I get a connection error.

 

If I set my default role to USR_ROLE_DATA_ENGINEER, I can log into Power BI using AAD either leaving the 'Specify a text value to use as Role name (optional)' empty, or entering the value USR_ROLE_DATA_ENGINEER. If I enter any other value (including PUBLIC), I get a connection error.

 

  • 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!