Skip to main content
The BigQuery destination writes canvas output to a table in Google BigQuery.

​
Authentication

Less connects to BigQuery with a Google Cloud service account JSON key. This is the recommended approach for automated load jobs. OAuth (sign in with Google) is not supported yet for BigQuery. Other Google connectors in Less (such as Google Sheets) use OAuth, but the BigQuery source and destination currently require a service account. See How to create a BigQuery service account for step-by-step instructions.

​
Setup

1

Account

Enter your Google Cloud project ID. Optionally set a default dataset so canvas nodes can use short table names, and a location if your load jobs run in a specific region.
2

Credentials

Upload your service account JSON key file. The service account needs BigQuery Data Editor on the destination dataset and BigQuery Job User at project level so Less can run load jobs.See How to create a BigQuery service account if you need help creating the key.
3

Test Connection

Click Connect to verify the credentials and permissions before saving the destination.
On the canvas, set the output table name as dataset.table, or project.dataset.table when you need to override the configured project or dataset. Supported operations are overwrite and append.