Stored Procedures
Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
CData BizTalk Adapter for Google BigQuery Stored Procedures
| Name | Description |
| CancelJob | Cancels a running BigQuery job. |
| CreateSchema | Creates a schema file for the specified table or view. |
| DeleteTable | Deletes the specified table from Google BigQuery. |
| GetJob | Inserts a Google BigQuery job, which can then be selected later to retrieve the query results. |
| GetOAuthAccessToken | Obtains the OAuth access token to be used for authentication with various Google services. |
| GetOAuthAuthorizationURL | Obtains the OAuth authorization URL for authentication with various Google services. |
| InsertJob | Inserts a Google BigQuery job, which can then be selected later to retrieve the query results. |
| RefreshOAuthAccessToken | Obtains the OAuth access token to be used for authentication with various Google services. |