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 |