Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT/INSERT/UPDATE/DELETE operations with Google BigQuery.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Google BigQuery, along with an indication of whether the procedure succeeded or failed.
CData MCP Server for Google BigQuery Stored Procedures
| Name | Description |
| CancelJob | Cancels a running BigQuery job. |
| DeleteObject | Deletes an object from a bucket. |
| DeleteTable | Deletes the specified table from Google BigQuery. |
| GetJob | Retrieves the configuration information and execution state for an existing job. |
| 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. |
| InsertLoadJob | Inserts a Google BigQuery load job, which adds data from Google Cloud Storage into an existing table. |
| RefreshOAuthAccessToken | Obtains the OAuth access token to be used for authentication with various Google services. |
| UploadObject | Uploads objects in a single operation. Use the SimpleUploadLimit connection property to adjust the threshold in bytes in order to perform a multipart upload. |