Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components 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. |