GetOAuthAccessToken
Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Snowflake.
Input
| Name | Type | Required | Description |
| AuthMode | String | False | Specifies the authentication mode to use. Allowed values: 'APP' for application-based authentication, 'WEB' for browser-based authentication requiring user interaction. |
| CallbackUrl | String | False | The URL to which the user is redirected after completing the OAuth authorization process. |
| Verifier | String | False | A one-time verifier code returned by Snowflake after the user grants authorization. Required only when using 'WEB' authentication mode. |
| PKCEVerifier | String | False | A code challenge used for Proof Key for Code Exchange (PKCE) validation. Generated and returned by GetOAuthAuthorizationURL. |
| Prompt | String | False | Determines the type of prompt shown during authentication. Options: 'select_account' prompts the user to choose an account, 'None' disables prompts, 'login' forces a credential entry, and 'consent' displays an OAuth consent dialog for permission approval. |
Result Set Columns
| Name | Type | Description |
| OAuthRefreshToken | String | A token that can be used to request a new OAuth access token without requiring the user to reauthenticate. |
| OAuthAccessToken | String | The OAuth access token required for authenticating API requests to Snowflake. |
| ExpiresIn | String | Indicates how long the access token remains valid, measured in seconds. A value of -1 means the token does not expire. |