The BigQuery service lets you use the Google BigQuery API in Google Apps Script. This API gives users the ability to manage their BigQuery projects, upload new data, and execute queries.

This is an advanced service that must be enabled before use.

Reference

For detailed information on this service, see the reference documentation for the BigQuery API. Like all advanced services in Apps Script, the BigQuery service uses the same objects, methods, and parameters as the public API. For more information, see How method signatures are determined.

To report issues and find other support, see the Google Cloud support guide.

Sample code

The following sample code uses version 2 of the API.

Run query

This sample queries a list of the daily top Google Search terms.

Load CSV data

This sample creates a new table and loads a CSV file from Google Drive into it.