CData Excel Add-In for Google BigQuery 2019 - Online Help
Questions / Feedback?

Stored Procedures

CData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354

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 Excel Add-In for Google BigQuery 2019 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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0