Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the adapter beyond simple SELECT/INSERT/UPDATE/DELETE operations with Snowflake.
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from Snowflake, along with an indication of whether the procedure succeeded or failed.
Snowflake Adapter Stored Procedures
| Name | Description |
| GetOAuthAccessToken | If using a Windows application, set Authmode to App. If using a Web app, set Authmode to Web and specify the Verifier obtained by GetOAuthAuthorizationUrl. |
| GetOAuthAuthorizationUrl | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. |
| GetSSOAuthorizationURL | Gets Browser-based SSO authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to Snowflake. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Snowflake. |