JDBC Driver for Snowflake

Build 24.0.9060

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver 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 JDBC Driver 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060