Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT 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 Power BI Connector 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 | 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. |