79570194

Date: 2025-04-12 08:13:53
Score: 2
Natty:
Report link

If the use case that you are working on requires you to switch roles in the session created via the OAuth access token, then you shall have to use the scope as SESSION:ROLE-ANY.

In addition, on the Snowflake account, please verify that the parameter EXTERNAL_OAUTH_ANY_ROLE_MODE is set to True.

Reference:

https://docs.snowflake.com/en/sql-reference/sql/alter-security-integration-oauth-external

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: anshul.anand