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 |