Update Spreadsheets with data from Google BigQuery does not work

2
votes

I followed the instruction at https://developers.google.com/apps-script/articles/bigquery_tutorial to populate a Spreadsheet with BigQuery data. I followed the steps but when I run the BigQuery -> Run Query in the spreadsheet, I get the error "Exception: Required parameter is missing".

I used the exact same piece of code in example with the following line changed to: var projectNumber = '770233629555';

Could anyone please assist?

1
google-bigquery

1 Answers

1
votes

Check out the red bar at the top of the doc that says: "Please note that some of the methods below have incorrect parameters listed. See this blog post for the required changes."

For instance, you'll want to change the BigQuery.query line to:

var resource = {
  query: query,
  timeoutMs: 1000
};
result = BigQuery.Jobs.query(resource, projectId);

Also, check out the full AppsScript example here.