JDBC Driver for Google Sheets

Build 22.0.8462

AddDataSource

Add a BigQuery dataSource to the specified spreadsheet. A Custom OAuth app with the scope bigquery.readonly is required to run this stored procedure.

Input

Name Type Description
SpreadsheetId String The ID of the spreadsheet.
ProjectId String The ID of a BigQuery enabled GCP project.
TableProjectId String The ID of a BigQuery project the table belongs to. If not specified, the projectId is assumed.
DatasetId String The BigQuery dataset id.
TableId String The BigQuery table id.
BigQueryQuery String The query to use when querying the DataSource

Result Set Columns

Name Type Description
Success String This value shows whether the operation was successful or not.
DataSourceId String The ID of the created DataSouce
Status String The DataExecution Status

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462