Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Snowflake.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Snowflake, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Snowflake Stored Procedures
| Name | Description |
| GetOAuthAccessToken | If you are using a Windows application, set Authmode to App. If you are 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. You can access the URL returned in the output in a Web browser. This requests the access token that is used as part of the connection string to Snowflake. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token that is used for authentication with Snowflake. |