UpdateDataSourceRequest

Updates a data source. After the data source is updated successfully, an execution is triggered to refresh the associated DATA_SOURCE sheet to read data from the updated data source. The request requires an additional bigquery.readonly OAuth scope.

{
    "dataSource": {
        "calculatedColumns": [
            {
                "formula": "string",
                "reference": {
                    "name": "string"
                }
            }
        ],
        "dataSourceId": "string",
        "sheetId": 0,
        "spec": {
            "bigQuery": {
                "projectId": "string",
                "querySpec": {
                    "rawQuery": "string"
                },
                "tableSpec": {
                    "datasetId": "string",
                    "tableId": "string",
                    "tableProjectId": "string"
                }
            },
            "parameters": [
                {
                    "name": "string",
                    "namedRangeId": "string",
                    "range": {}
                }
            ]
        }
    },
    "fields": "string"
}